Skip to main content
Solved

PowerBI: credentials failing on OData connection despite successful XML view of OData Generic Inquiries


arlinewelty93
Jr Varsity III
Forum|alt.badge.img

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!

Best answer by arlinewelty93

@Gabriel Michaud That was it! Just like when using Report Designer- got it.

And why am I not surprised that Velixo handles this so nicely?

View original
Did this topic help you find an answer to your question?

9 replies

Gabriel Michaud
Captain II
Forum|alt.badge.img+10

Hi @arlinewelty93,

Make sure to include the tenant name after your user name when you login, ex: user@Tenant… I think this is the issue here.

P.S. that’s one more thing that Velixo handles transparently for you (with Acumatica single sign-on and multi-factor authentication as well - something you can’t do with Power Query) 😉


arlinewelty93
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 19 replies
  • Answer
  • June 24, 2021

@Gabriel Michaud That was it! Just like when using Report Designer- got it.

And why am I not surprised that Velixo handles this so nicely?


  • Freshman I
  • 3 replies
  • January 26, 2023

I tried the solution mentioned, but still no luck. the tenet has two spaces and an apostrophe in it, so I used the type that shows on the login screen to get into Acumatica. Any other ideas?

 


DavidEichner
Captain II
Forum|alt.badge.img+13
  • Captain II
  • 373 replies
  • January 26, 2023

Hi @jsparks62 

It might be the apostrophe that is the issue. You could setup a test tenant without an apostrophe and then test against that.

Best,

David EIchner, CPA


  • Freshman I
  • 3 replies
  • January 27, 2023

Yes, that is the problem. But How do I get around it when the data I need is in the tenet with the apostrophe? Is changing the tenant name an option?

 


DavidEichner
Captain II
Forum|alt.badge.img+13
  • Captain II
  • 373 replies
  • January 27, 2023

Yes, you can change the Tenant Name

Best,

David Eichner, CPA


  • Freshman I
  • 3 replies
  • January 27, 2023

Thanks for the help!


@Gabriel Michaud do you know if Active directory usernames affect this at all or could spaces in tenant affect this at all. We are experiencing the same issue

 

Thank you


Gabriel Michaud
Captain II
Forum|alt.badge.img+10

@mgrovergeiger this won’t work with federated logins using Azure Active Directory or ADFS. You can only use an Acumatica account using basic authentication to login via OData. If you’re using the “old” type of AD integration where you enter domain\username and your AD password on the Acumatica login screen that there’s a possibility that it might work.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings