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

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/

 

View solution in original post

5 REPLIES 5

@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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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"

@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

 

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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 

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/

 

View solution in original post

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