Accessing Analytical Workspaces and Reports on 1Box environment


This article describes the process for enabling Analytical Workspaces & Reports in Dynamics 365 for Operations 7.2 Release on a 1Box environment.  This information is intended for partners, VARs, and ISVs that wish to showcase Analytical Applications using a 1Box environment.  As described in the Power BI Embedded Integration article, the hosted service used to deliver embedded analytics is only available on High-Availability deployments.  The Power BI Embedded service is not configured for 1Box environments.  As a result, the embedded Analytical Applications only available in High-Availability environments.

The following describes a *hack* that can be used to access the Analytical Workspaces & Reports on a 1Box environment.  To utilize this solution, you will need to deploy resources using the Azure portal on your subscription including an Azure SQL Server Database Premium (P1) edition to host the Entity Store.  To keep costs at a minimum, be sure to turn on the Azure services only when needed.

Note:  This configuration process an only be performed on a 1Box environment.  The service configuration settings are inaccessible in multi-box deployments.


In short, to access the Analytical Applications on a 1Box deployment, you'll need to deploy your own Power BI Embedded Service and Entity Store Database.  It's simple to do.  However, you'll need Administrative access to an Azure Subscription and a Dynamics 365 for Operations 1Box environment.

Essentially, this process includes the following steps:

  1. Deploy the Power BI Embedded service on your Azure subscription
  2. Deploy a SQL Database on your Azure subscription
  3. Publish the Entity Store database on your Azure subscription
  4. Configure the local 1Box environment to point at your Power BI Embedded service

Here's a screen shot of an Analytical Workspace in the Application Suite

The first step, is to Deploy the Power BI Embedded service on your Azure subscription.

Comments (3)
  1. In the article, you wrote: “To keep costs at a minimum, be sure to turn on the Azure services only when needed.”
    Can you provide some guidance and/or example scripts as I can’t find how to turn down a Azure SQL DB?

  2. RockyHere says:

    Thanks for this detailed article. Can you advise if we can periodically refresh the data on the reports/visuals as well to demonstrate the customer specific data? The system shows the data from Step 3 in your article but does not refresh it because of obvious reasons. Are there any *hacks* for that as well?

    Appreciate your help and time.


  3. How to do this using Power BI Embedded (Latest release on Azure) for D3FO v8.x +?

Comments are closed.

Skip to main content