Showing results for 
Search instead for 
Did you mean: 

Enterprise Gateway - connection to PWA OData?

When setting up data sources in the Enterprise Gateway, I am not able to connect to PWA OData. 


In the Desktop, I successfully connect to the same OData via my Organizational Account. However, this option does not appear in the Enterprise Gateway - the provided options (Anonymous, Basic and Windows) are not valid for the data source.


Is connection to PWA OData supported? If so, what is the recommended approach re: authentication?






Resident Rockstar
Resident Rockstar

From the fine documentation:


Currently, the gateway allows for the use of DirectQuery to an on-premises SQL Server or SAP HANA, as well as a live connection to Analysis Services. You can use a live connection to either a tabular or multidimensional model in Analysis Services.

Does that mean OData is not supported yet?



While OData is supported in PowerBI, automatic refresh of OData via the Enterprise Gateway is not supported at this point. Current approach = refresh of OData via the Personal Gateway. 





We are unable to see live data with the Personal Gateway when the report is embedded into Dynamics AX7. We are only able to get the data to refresh by re-publishing the dashboard. Are we missing something?

Resident Rockstar
Resident Rockstar

Personal gateway wont support live connection.

What's the process to request this as a new feature? We have quite a few people who might benefit from this.



Great question. There is a forum where you can cast votes on existing suggestions (or create new questions). I did a quick search on OData and came up with this list:  


PowerBI Ideas re: Odata


I wish I could point you to the exact question/solution that would get you to the top of the list.


In the meantime, I am looking at some options and will post here if I have an update.





Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors