cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snetsmart Frequent Visitor
Frequent Visitor

OData credentials not working in Power BI Desktop; works fine in Excel

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
snetsmart Frequent Visitor
Frequent Visitor

Re: OData credentials not working in Power BI Desktop; works fine in Excel

Thank you! I figured it out, as it worked from a remote location. It's actually a setting on the server -- forms authentication needs to be checked when signing in with ADFS. This link explains it, but hopefully will help someone else with the same issue in the future.

 

https://powerbi.microsoft.com/en-us/blog/error-signing-in-with-adfs-and-azure-ad/

 

5 REPLIES 5
Super User
Super User

Re: OData credentials not working in Power BI Desktop; works fine in Excel

@snetsmart What is your Odata source? I think I ran into this initially when connecting to Project online. The user I was signing in with was not my own, so I had to sign out of the PBI Desktop and sign in with that user account.

Also, in that instance, for some reason even though the metadata returned table names in the singular "Project" the Odata connection was to "Projects". - don't know if this applies at all, but those were two recent things I had to work through when using Odata.

Near SE WI? Join our PUG Milwaukee Brew City PUG
snetsmart Frequent Visitor
Frequent Visitor

Re: OData credentials not working in Power BI Desktop; works fine in Excel

My source is also Project Online. But, I'm signing in with my own credentials on both sides.

 

I'm using the URL "......sharepoint.com/sites/pwa/_api/ProjectData"

Super User
Super User

Re: OData credentials not working in Power BI Desktop; works fine in Excel

@snetsmart Hmm. Do you have the right permissions on the Project Online side?

I used: https://<InstanceName>.sharepoint.com/sites/pwa/_api/ProjectData

signing in using the Organizational account

 

 

Near SE WI? Join our PUG Milwaukee Brew City PUG
trebgatte Member
Member

Re: OData credentials not working in Power BI Desktop; works fine in Excel

This is odd as the permissions on the Project side should globally allow or deny data access, regardless of entry point. If you put the OData url in your browser and log in when prompted, does it return data?

 

I'll see if there's any known issues at the moment on my Project MVP email group. Also, which version of Power BI Desktop and Excel are you using? 

 

Treb Gatte | Business Solutions MVP | Power BI Recordings | @tgatte | Blog 

snetsmart Frequent Visitor
Frequent Visitor

Re: OData credentials not working in Power BI Desktop; works fine in Excel

Thank you! I figured it out, as it worked from a remote location. It's actually a setting on the server -- forms authentication needs to be checked when signing in with ADFS. This link explains it, but hopefully will help someone else with the same issue in the future.

 

https://powerbi.microsoft.com/en-us/blog/error-signing-in-with-adfs-and-azure-ad/

 

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: 5 members 3,518 guests
Please welcome our newest community members: