cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Krizz83
Regular Visitor

Project Online Odata - "The user was not Authorized"

I am trying to connect to PowerBi with oData from our Project Online.

I keep getting "the User was not Authorized" when trying to signin using my Organizational account. I am 100% sure I am fully qualified for this access.

This is happening when trying to load the data once I selected the Table I want from oData feed.

 

I can also load the preview data.

 

Anyone would tell if he/she is facing/has faced same issue? And maybe how to address this?

3 REPLIES 3
xylus
New Member

I am also unable to form a connection to ProjectData via OData using PowerBI against multiple instances today.

 

This seems like a repitition of the situation that people experienced in July.

 

 

Krizz83
Regular Visitor

Yes, i also saw those.

Can someone from the PowerBI team comment on this?

What I found to be true about this error is that it might be spurious:

 

When I reduced the number of columns that I selected from in my query of the Projects table down from the 137 columns by 23 records to something more in the range of the 18 - 25 columns that I specifically need in my query - I found this problem went away.  So the question becomes - is the spurious error being created by a time-out, by a misread of the select all mechanism or what?

 

I realize that we want to simplify our data requests but this was a very simple query with a very limited subset of data - so I don't see why it should have choked in this way.

 

Happily I've gotten around it - that being said - this is going to confuse a whole lot of people.

 

Cheers!

Xylus

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors