cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jcmouniapin New Member
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

Accepted Solutions
Super User
Super User

Re: Odata error - "The user was not authorized"

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

3 REPLIES 3
Super User
Super User

Re: Odata error - "The user was not authorized"

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

snetsmart Frequent Visitor
Frequent Visitor

Re: Odata error - "The user was not authorized"

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.

 

 

MikeSmallwood Frequent Visitor
Frequent Visitor

Re: Odata error - "The user was not authorized"

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 307 members 3,344 guests
Please welcome our newest community members: