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
jcmouniapin
New Member

Odata error - "The user was not authorized"

Hello,

 

I have got the error "The user was not authorized" when I try to access to an OData Feed.

 

But when I try to access to the same OData Feed using Excel 2013, it works fine. i would like to understand why it is working with Excel and not with Power BI Desktop.

 

Can someone help and guide me to solve my problem, please?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Best thing you can do is probably send a frowny face to support and then they are going to ask you to turn on tracing, Options & Settings | Options | Diagnostics | Enable Tracing and then send them the file.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
snetsmart
Frequent Visitor

I, too, am having the same issue. I've tried to use oauth to use the odata feed in Power BI Desktop and I get "Unable to connect. Check your credentials." However, I am able to access the same tables via Excel with the same credentials.

 

 

Please could you let me know if there has been a resolution to this issue. I'm using OData Data Source with Basic authentication. The connection works via a browser or Excel but presents "the user not authorised" message when trying to connect via Power BI Desktop.

 

 I can send a trace file if it helps

Greg_Deckler
Super User
Super User

Best thing you can do is probably send a frowny face to support and then they are going to ask you to turn on tracing, Options & Settings | Options | Diagnostics | Enable Tracing and then send them the file.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.