Connect to Acumatica with Power BI
The Power BI Acumatica content pack allows to you quickly gain insights into your opportunity data. Power BI retrieves your data, including opportunities, accounts, and customers, then builds a default dashboard and related reports based on that data.
This content pack requires Acumatica v5.2 or higher.
How to connect
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select Acumatica > Get.
Enter your Acumatica OData endpoint. An OData endpoint allows an external system to request data from Acumatica. Acumatica OData endpoint is formatted as follows and should us HTTPS:
The Company Name is only required if you have a multi-company deployment. More information about finding this parameter in your Acumatica account is included below.
For Authentication Method, select Basic. Enter your username and password from your Acumatica account, then click Sign In.
After Power BI imports the data you will see a new dashboard, report, and dataset in the left navigation pane. New items are marked with a yellow asterisk * which disappears once selected, chosing the dashboard will show a similar layout to the one below:
- Try asking a question in the Q&A box at the top of the dashboard
- Change the tiles in the dashboard.
- Select a tile to open the underlying report.
- While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now
This content pack requires Acumatica v5.2 or higher, please confirm the version with your Acumatica admin.
Acumatica OData Endpoint
The Acumatica OData endpoint is formatted as follows and should us HTTPS:
The Application Site Domain can be found in your browser’s address bar when you’re signed into Acumatica. In the example below, the site domain is “https://pbi.acumatica.com” so the OData endpoint to provide would be “https://pbi.acumatica.com/odata”.
The Company Name is only required if you have a multi-company deployment. You can find this information from your Acumatica sign in page.
If you’re not able to login, verify the Acumatica OData endpoint you provided is formatted correctly.
https://<application site domain>/odata/<company name>
If you're having trouble connecting, please confirm with your admin your version of Acumatica. This content pack requires version 5.2 or later.