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

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
Ironpixel
Microsoft Employee
Microsoft Employee

Manage Gateways - Adding Odata Connection

Hello,

I am trying to setup my Gateway and have successfully added a folder under Data Source Settings.

Unfortunately when trying to add a link to the Odata URL I can't seem to get past authentication.

This is organizational data, yet my only options for signing in are Anonymous, Basic, Windows, and none seem to work.

 

What am I missing.

The help seems to lead me to believe this is possible.

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Ironpixel,

When connecting to OData via organizational account in Power BI Desktop, we are not able to schedule refresh for the OData dataset as On-premises Gateway only provides these authentication options: Anonymous, Basic and Windows. Regarding to this issue, you can vote it in this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13382847-organizational-authentic... .

In your scenario, to work around the refresh issue, please use Personal gateway instead.


Thanks,
Lydia Zhang

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Ironpixel,

When connecting to OData via organizational account in Power BI Desktop, we are not able to schedule refresh for the OData dataset as On-premises Gateway only provides these authentication options: Anonymous, Basic and Windows. Regarding to this issue, you can vote it in this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13382847-organizational-authentic... .

In your scenario, to work around the refresh issue, please use Personal gateway instead.


Thanks,
Lydia Zhang

Hi @Anonymous 

Thank you for this.  I have attempted to use a personal gateway however that wasn't working either. 


I have no problem refreshing my Odata with the Desktop app.  When trying to schedule the refresh with PBI Online I am asked to updated my credintials.  This seems to work for the Excel data, but not the Odata query.  It seems that I require Organizational access as thats what I use for the OData with the Desktop App.  We are looking forward to that option as we are hoping to roll what I have created out accross WDG Design.

 

In the mean time...

Thank you for the link! I have voted it up!

Did this ever get solved as we have just lost the ability to use the personal gateway and therefore need to use the Enterprise gateway instead.  However we now have issues on both sides meaning that neither will work for us !!

 

Just need to be able to have OData connection to Dynamics along with onpremises files available in a single gateway process.

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors