04.02.2019, 01:49 | #1 |
Участник
|
everythingdynamicsaxbi: How to: Configure Power BI Embedded for Dynamics 365 for Finance and Operations (One-box environment)
Источник: http://www.everythingdynamicsaxbi.co...x-environment/
============== You have your development or test box deployed and running, and everything is working perfectly until you load a workspace containing Power BI Embedded and you are faced with this error: This post will show you how to get the Analytics in the Workspaces working for one-box environments. Important! The information presented in this blog are provided “AS IS” with no warranties and confer no rights. You assume all risk for your use. Prerequisites
1.Azure Portal
My database properties: 2.Power BI Embedded The Power BI Embedded experience in Dynamics 365 for Finance and Operations relies on the Power BI Workspace collections on Azure. This feature was deprecated on June 2018 and we have not recieved any information from Microsoft on how this will be in the future. Currently the workaround described in the next steps are still working:
2. Click on “Build your own template in the editor” 3. Input this text in the template editor and input your Power BI workspace collection name (You can also change it to your preferred Azure region): { “$schema”: “https://schema.management.azure.com/...e.json#”, “contentVersion”: “1.0.0.0”, “parameters”: {}, “resources”: [ { “type”: “Microsoft.PowerBI/workspaceCollections”, “sku”: { “name”: “S1”, “tier”: “Standard” }, “name”: “GIVE YOUR PBI WORKSPACE COLLECTION A NAME HERE!!!!”, “apiVersion”: “2016-01-29”, “location”: “North Europe” } ] } 4. Save the template and select a resource group or create a new one. Click on “Purchase”. 5. After creating the Power BI workspace collection, open it and copy the access keys into Notepad. You will need them later. 3.Add and change users in the AxDW (Entity store) To give D365DO access to the newly created Entity Store (AxDw) we need to create some users and add them to the database. Logon to your VM and run the following queries inside SQL Management Studio (Connect to your newly created AxDw, username and password will be the same as you used in the first step) 1. Create a new query in the “master” database. Insert the following: CREATE LOGIN axdwadmin WITH PASSWORD = ‘samepasswordasinyourlcsenvironment’; CREATE LOGIN axdwruntimeuser WITH PASSWORD = ‘samepasswordasinyourlcsenvironment’; 2. Run the query 3. Create a query in the “AxDw” database and run the following: CREATE USER axdwadmin FROM LOGIN axdwadmin; CREATE USER axdwruntimeuser FROM LOGIN axdwruntimeuser; 4. Then, create this query in the “AxDw” database and run the following: ALTER ROLE db_owner ADD MEMBER axdwadmin; ALTER ROLE db_datareader ADD MEMBER axdwruntimeuser; Where can I find the usernames and passwords in LCS?
4.Tweaking the web.config file: First, search for this line and replace it with your server name:
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
Теги |
d365fo, power bi |
|
Опции темы | Поиск в этой теме |
Опции просмотра | |
|