cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Hshen
New Member

Re: Unable to access an odata feed from Acumatica?

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
Microsoft
Microsoft

Re: Unable to access an odata feed from Acumatica?

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.
Hshen
New Member

Re: Unable to access an odata feed from Acumatica?

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors