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:

Second, add these lines to the end of the section, right before :

Paste in the keys you copied from the Azure portal in here:

Save the config file.

After editing the web.config file, perform a restart of IIS on the VM. When up and running again, logon to the D365FO client and make sure that everything runs like it should. Then do a restart of the batch service:



Do a refresh of the Aggreagate Measurements (See this article if you are unsure on how to do this)

Then go to a workspace and select the Analytics tab – the Power BI Embedded reports will be deployed “automagically” (Actually D365FO deployes the reports when you click the Analytics tab for the first time) :)




Any questions or comments feel free to reach out to me on email or via the comment section below.