Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 04.02.2019, 01:49   #1  
Blog bot is offline
Blog bot
25,531 / 847 (80) +++++++
Регистрация: 28.10.2006
everythingdynamicsaxbi: How to: Configure Power BI Embedded for Dynamics 365 for Finance and Operations (One-box 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.

  • Access to Azure Portal and rights to deploy Azure SQL Database
  • Access to VM and SQL Management Studio for your environment
Step by step…

1.Azure Portal
  1. First, head over to the Azure portal and create a new Azure SQL database. There are some requirements for creating the database, see below table:

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:
  1. Log onto the Azure Portal and click on Create a resource and do a search for Template deployment. Click Create:

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”: “”,
“contentVersion”: “”,
“parameters”: {},  
“resources”: [
“type”: “Microsoft.PowerBI/workspaceCollections”,
“sku”: {
“name”: “S1”,
“tier”: “Standard”
“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?
  1. Logon to and select your project.
  2. Select your environment
  3. Scroll down and you will see the domain accounts and you can then chose to view the passwords for each user:

4.Tweaking the web.config file:

First, search for this line and replace it with your server name:
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
d365fo, power bi


Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
powerobjects: How to Integrate Power BI with Dynamics 365 for Finance and Operations Blog bot Dynamics CRM: Blogs 0 26.06.2018 01:23
everythingdynamicsaxbi: Power BI: Parameter iFrameEmbedUrl cannot be null or empty (Dynamics 365 for Finance and Operations) Blog bot DAX Blogs 0 28.11.2017 18:11
everythingdynamicsaxbi: Reporting in Dynamics 365 for Finance and Operations – The definitive guide Blog bot DAX Blogs 0 02.11.2017 22:11
dynamicsaxbi: Deploy Power BI Embedded Service for Dynamics 365 for Operations Blog bot DAX Blogs 0 29.07.2017 22:17
stoneridgesoftware: Configuring Power BI Integration for Dynamics 365 Workspaces Blog bot DAX Blogs 1 07.03.2017 10:04
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 14:08.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.