Questions PowerBI: XML to see all GIS works great. But in PowerBI, credentials fail.
Looking for some OData insight here.
I have the XML page working great with the "Odata" test URL following the naming convention: http://<application site domain>/odata/<company name>
So naturally I thought I was on easy street when that loaded!
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 through 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.
These same credentials are the ones I used to view the XML "Odata Test" URL above and are also the credentials I used to write the Inquiry.
I suspect there is a configuration setting within Acumatica (User Right by Screen?) that I need to adjust. Suggestions?
Thanks for any insights!
p.s. I see something similar in this post
Can you get it to work if you put that OData URL in your browser? The browser should prompt for your username/password, then it will show you the XML if successful. That would help determine if it's a Power BI problem or an OData problem.
Also, are you using Get Data on PowerBI.com or in Power BI Desktop?
Tim, hi! Yes, the OData URL worked great in my browser, which is why I was flummoxed when I got these results. Ultimately the issue was that I needed to add the Tenant name to my sign-on credentials in Power BI (which I didn't have to do when I was just viewing the OData results in the browser).
Thanks for the response! This was in Power BI Desktop, if anyone else sees this thread and has the same issue I reported.