Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors