Unable to access an odata feed from Acumatica?

[Hshen]

I was able to authentica into the Acumatica database and able to see the inquiry that was Odata feed enabled but when I click on the inquiry in Get Data, I receive an error message 'Not authorized to use this resource'. Other Odata feed that came with the default in the database does not give me that error message.

So, I have proven that I was authenticating into the Acumatica database correctly by getting data from another inquiry from the database but the new one that I written gives me the "not authorized to use resource" error message.

Anybody worked with Acumatica and PowerBI out there?

[v-yuezhe-msft]

Hi @Hshen,

I am not familiar with Acumatica.

Based on your description, you connect to Acumatica via OData Feed in Power BI Desktop, right?


If that is the case, according to the above error message, you don’t have access to the problem inquiry. Are you able to view the problem inquiry by using the following URL?  Please check that if you have proper security access permissions for Acumatica inquiry and I would recommend you follow the steps in this blog to connect to Acumatica from Power BI Desktop.

http://<application site domain>/odata/<company name>/<Generic Inquiry Name>

In addition, do you get desired reports when directly connecting to Acumatica content pack from Power BI Service?

Thanks,
Lydia Zhang

[Hshen · Accepted solution]

I managed to resolved the issue. The original query returns too many columns for Power BI, by reducing the number of columns in the query inside Acumatica, I was able to connect to the query as an OData Feed and loaded the data into Power BI.

The error message of 'not authorized to access this resource' is very confusing.