cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hshen
New Member

Unable to access an odata feed from Acumatica?

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?

1 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.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft
Microsoft

Hi @Hshen,

I am not familiar with Acumatica.

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

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors