Hello all,
Looking for some OData insight here. The goal: pull a Generic Inquiry through to Power BI.
I have the XML page working great with the "Odata" test URL following the naming convention: http://<application site domain>/odata/<company name>
I assumed that was the “test” that would ensure that I’d be able to connect to an OData endpoint within an Acumatica instance.
However, when I attempt to "Get Data" through Power BI and load in the URL with basic authentication, I have tantalizing visibility to the Inquiries, including the one I want to use, but I'm unable to get past the authentication step in order to finish loading data from the data source.
Perplexingly I can't seem to use my regular credentials using Basic authentication, at any level.
Here’s the XML. This loads after prompting for Acumatica credentials.
However, when I use the same URL and enter the same credentials into “Basic” authentication I’m getting the credentials error:
From looking online, I’m curious if this is a specific formatting issue related to the OData feed URL, or maybe a “user rights by screen” setting that needs to be configured differently.
Interested to hear what others would do to troubleshoot this.
Thank you!