Configuring 1Box to enable Analytical Workspaces and Reports


At this point, you should have access to an Entity Store database hosted on the Azure SQL Server available using the process outlined in the previous step.  Use the instructions below to enable Analytical Workspaces & Reports in a 1Box environment using the Power BI Embedded service hosted on your Azure subscription.

To continue make sure you have the following information:

Entity Store Database Service details:

  • Database name:  Name provided in the database settings
  • Server name:  Azure SQL Server name (*.database.windows.net)
  • Server admin login:  User name supplied in the SQL Server settings
  • Password:  Account password supplied when configuring SQL Server

Power BI Embedded Service details:

  • Workspace Collection Name: The name of the Workspace Collection created when deploying the Power BI Embedded Service
  • Access Key1:  The secret key #1 used to access the Power BI Embedded service
  • Access Key2:  The secret key #2 used to access the Power BI Embedded service

KEEP THESE KEYS CONFIDENTIAL...!  You'll want to protect this information as appropriate to prevent exposing Azure services to others.  Developers can use this information to remotely access the Power BI Embedded Service and SQL Azure Database Server.  Microsoft is not responsible for the implications of sharing these service keys with others.  Should this information become compromised, use the Azure Service Portal tools to regenerate the Power BI Embedded service security keys.

Configure 1Box environment to enable Analytical Workspaces & Reports

  1. Open the File Explorer on the local 1Box environment
  2. Navigate to the root folder for the local Dynamics 365 for Operations deployment (e.g. C:\AOSService\webroot)
  3. Recommend that you make a copy of the web.config file before making any changes
  4. Edit the web.config file in the folder using Notepad
  5. Update the Entity Store Database configuration settings:

<add key="BiReporting.DW" value="[Database name]" />
<add key="BiReporting.DWServer" value="[Server name]" />
<add key="BiReporting.DWRuntimeUser" value="[Server Admin login]" />
<add key="BiReporting.DWRuntimePwd" value="[Password]" />

6. Update the Power BI Embedded Service configuration settings:

<add key="PowerBIEmbedded.AccessKey" value="[Access Key1]" />
<add key="PowerBIEmbedded.AccessKey2" value="[Access Key2]" />
<add key="PowerBIEmbedded.ApiUrl" value="https://api.powerbi.com" />
<add key="PowerBIEmbedded.IsPowerBIEmbeddedEnabled" value="true" />
<add key="PowerBIEmbedded.WorkspaceCollectionName" value="[Workspace Collection Name]" />

7.   Close Notepad and Save your changes
8.   Open Command Prompt
9.   Reset IIS to apply the changes using the command:  iisreset
10. Once it completes, launch the Dynamics 365 for Operations instance running on the local 1Box, and access an Analytical Workspace [Manage customer credit and collections]

You're ready to go...!  You can now access the Analytical Workspaces & Reports in the Application Suite using the local 1Box deployment.  The Dynamics 365 application automatically deploys Power BI reports on-demand so there's no need to manually deploy reports.


Comments (8)

  1. Tran Hung says:

    Hi

    i followed the guideline, the Power BI report are embedded now. But when run analytical. The error is “Couldn’t load the schema for the database model”

    Hung

  2. DRT_Sikich says:

    Are these instructions still valid for 7.3? The PowerBIEmbedded keys did not exist in the web.config for T1 env’s and even after adding them with correct values the workspace comes up and appears to be connecting to powerbi (no longer receive a message that menu item could not be opened which is indicative if powerbiembedded is not enabled). Event logs show this: The installer argument in web.config is null.

    1. Tommy Skaue says:

      Just paste in the section if those configurations are missing. Not important for some, but for me, is to make sure the configuration perfectly aligns downwards, with enough spaces in front of each line. 😉 #aesthetics #ocd

  3. M.Baur says:

    Hi

    i found this in the instructions how to set it up…..but whats now after june 2018?

    NOTE (New in V2.3): Power BI Workspace collections will be deprecated in June 2018. How Power BI
    Embedded will work in a Dynamics 365 for Finance and Operations OneBox environment afterwards
    is yet unknown…

    Does anybody has an update how to do it now? The new way…..

    Regards
    Marcel

  4. vmessy_ says:

    Hello,
    Has anyone managed to get this working on 8.1?
    I have a fresh box and my web.config does not contain the section for step 6, Power BI Embedded Service.
    Cannot update the values as they do not exist.
    Is it a case to copy and paste these in and change the settings accordingly? I will try it and refer back.

    1. The response from Tommy is still valid for 8.1. Add the missing keys and it works!

      1. Hi,

        So i’ve been working through the steps found here: https://blogs.msdn.microsoft.com/dynamicsaxbi/2017/07/29/accessing-analytical-workspaces-on-1box-environment/

        Just stuck now on getting the right information for the Power BI Embedded Settings

        Where do I obtain the Access Keys for my Power BI Embedded Capacity, I can’t find them in Azure, unless i’m being blind? and Is a value for PowerBIEmbedded.WorkspaceCollectionName still required considering Workspace Collections have now been deprecated?

        Thanks
        Ben

        1. AntonZhong says:

          Hi, same case with me, what value should we key in in that Access Key and Access Key2 Web.config ?

Skip to main content