Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
brade
New Member

Cannot refresh dataset

I have set a Data Management Gateway on an on-premise server in our environment and configured it through Power BI Admin Center for availability as an oData feed. I've then been able to use PowerQuery in both Excel and PowerBI for Desktop to access the data.

 

Once I've got a model built, I can load the file to PowerBI.com and the dataset is loaded correctly. However, at this point I am unable to refresh the data. Both manual and automatic refresh fails, as I'm unable to login to the dataset using oAuth2. When I attempt to login I get the following error:

 

Login failed

Activity Id: 2e3a7627-fa6a-42a2-9c1a-bb99bf7fa6d3
Request Id: 4f388bf5-8f9c-2545-44c2-94e13ac97025
Status Code: 400
Time: Sun Jul 26 2015 22:31:21 GMT-0400 (Eastern Daylight Time)
Version: 11.0.9167.449

 

These are the same credentials I use to connect to the oData feed from PowerBI for Desktop or Excel, which are my O365 organizational credentials.

 

Anyone know how to get around this?

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

What is the data source that you have enabled as an OData feed through your Data Mangement Gateway? Is it a SQL data source, Oracle, Power Query? If Power Query, what is the Power Query accessing, SharePoint list, Excel file, etc?

 

Does it follow/meet the rules specified here:

https://support.office.com/en-us/article/Supported-Data-Sources-and-Data-Types-cb69a30a-2225-451f-a9...

 

and here:

https://support.office.com/en-us/article/Data-source-prerequisites-Power-Query-6062cf52-c764-45d0-a1...

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

It was a SQL database. I was unable to get the issue resolved, but I was able to utilize the personal gateway to surface the data through an Excel model instead.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.