Manage Gateways - Adding Odata Connection

[Ironpixel]

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!

[v-yuezhe-msft · Accepted solution]

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

[Ironpixel]

Hi @v-yuezhe-msft 

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!

[mdawesdigitalk]

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.