cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.


Check-out my Back to School contest submission: Dinosaurs!

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.


Check-out my Back to School contest submission: Dinosaurs!

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 41 members 1,153 guests
Please welcome our newest community members: