Forum Discussion
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.
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
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.