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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

OData and Personal Gateway

I have a Power BI Desktop file with six datasources, one Azure Marketplace, one Excel Document and 4 OData feeds.


I want to refresh the data and I have set up personal gateway and it is working fine.


The Azure Marketplace and Excel Document look just fine in the Manage Data Sources (No exclamation mark) but the OData feed is not updated, the authentication on the OData feed is Windows Authentication but when I try to sign into it using Windows authentication I get Login Failed, Status Code 400 error.


Does anyone have any ideas what I could be doing wrong?


Another question, with the personal gateway are gateways and datasources at outdated?

Advocate II
Advocate II



I m facing one problem that odata service not given me 2400000 records from sql server, anybody can guide me. Please


personel gateway create mashup.container file in task manager and not deleted and consumes full memory of machine. 



vilas jadhav



Power BI Team
Power BI Team

And the personal gateway application or service is running as a Windows user with the appropriate level of access to the service?

Yes it is. It is running as my personal user and I can open the Odata in Explorer, view it in Power BI Desktop etc.

Hi there,


did you manage to resolve this? I'm having the same issue 😞

Yes, in my case it turned out to be https problem, using  legal certificate resolved the issue.

Maybe this might help, or it might help other who have similer issue

Nik- Shahriar Nikkhah

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors