Atlantic Oak

Local Dynamics 365 for Operations VM (AX7) & Power BI Integration

This article is obsolete. AxDB is no longer available in Dynamics 365 for Finance and Operations production environments. Currently application developers have either the option of using AxDW (the data warehousing database) which is available via Power BI embedded or use the BYODB approach.

Power BI is Microsoft's new business analytics service. Even though Power BI has a desktop editing application that you can use to design your graphs, Power BI is entirely cloud based. But your data, the data that you intend to graph using Power BI, does not necessarily have to be in the cloud, it can reside on your local computer. It is possible to link your local data to the service using the Power BI data gateway. Using this premise as a starting point I've managed to link my AxDB database on a local AX7 (Microsoft Dynamics 365 for Operations) Virtual Machine to power BI, using these simple steps:

Step 1. Create your PowerBI account.

Go to click on the "Get started free" button. Follow the on screen instructions.

Step 2. Register your application with PowerBI.

Log in to your PowerBI account you've created in Step 1 and then navigate to

Register an application with Power BI

Choose "server-side Web app", in the redirect URL type: and the Home Page URL can be any bogus URL.

Once you click on the Register App Button you will get a ClientID and a Client Secret. Write those two down, they are required by the AX7 PowerBI configuration screen.

Step 3. Install the local PowerBI gateway on the AX7 VHD.

Log into your PowerBI account and download the gateway (upper right corner):

Menu option for downloading the Power BI Data Gateway

When installing the gateway choose the "on premises data gateway" option.

You will then be asked to log in to the PowerBI account you've created in Step 1.

You will be prompted to name your gateway and create a gateway recovery key.

Step 4. Configure AX7.

Log into AX7, click on the hamburger on the upper left side and click on System Administration -> PowerBI:

System administration menu option in dynamics ax7 (Dynamics 365 for Operations)

Once you're in the PowerBI configuration screen:

Power BI configuration screen in Dynamics AX7 (Dynamics 365 for Operations)

Change the Azure ID tenant to your tenant eg: The Client ID is the client ID you got in Step 2, and the application key is the client secret.

You are now ready to go.

Step 5. Test Connectivity.

Log into your PowerBI account. Click on the gear icon and then on "Manage Gateways".

Manage gateways menu selection Power BI

Click on the "Test all connections" button. If the gateway computer is turned on the screen should display the "Online: you are good to go" message.

Gateway setup in Power BI

Step 6. Add a data source to the gateway.

Click on the "Add data sources to use the gateway link".

Datasource settings in power bi

Use the AOSUser/AOSWebSite@123 username/password combination.

Dynamics 365 F&O Development Services

Does your dev team have too much on their plate? We can help by handling big or small Dynamics 365 customization projects at a competitive rate. Click here.

File based integration system for Dynamics 365 Finance and Operations

The Atlantic Oak Document Exchange System allows your Dynamics 365 for Finance and Supply Chain Management system to directly pull or push XML or flat files to and from external systems via SFTP, FTP, FTPS, Azure Storage, Azure Files and other file servers. Click here.