CODEWITHSUNDEEP
ms-officepowerbiacumaticaacumatica-kb
C.J. Hope
C.J. Hope

Reputation: 29

Power BI to Acumatica Connection

I am having errors while trying to connect Power BI to my Acumatica. I am not sure if it is no set up correctly in Acumatica itself or if I am doing it wrong altogether. I have followed a lot of the steps I have found on the web. Some examples of these would be Tim Rodman and Microsoft. The errors I get when I try to log into Acumatica app on Power BI:

I get error #2 and #3 when I changed the url to have to the companyName at the end instead of just https://[sitedomain]/odata/. Error #2 url = https://[sitedomain]/odata/[companyname].

Any ideas will help.

Thanks,

Upvotes: 0

Views: 507

Answers (1)

PaulSw
PaulSw

Reputation: 48

URL # 2 is formatted in the same way that worked for me.

To resolve your problem I would suggest you back up a little and troubleshoot each step along the way.

1) Can you connect to your instance in Power BI and get a list of OData sources? If you can then your connection string and credentials are correct. If not this is where your issue is.

2) If you create a new query against one of the OData sources listed in (1) does it retrieve the data?

If it does then it suggests to me that your issue is within the query(s) you have created.

Without more details that's the best suggestion I can make.

Upvotes: 1

Related Questions