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?
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.
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?
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:
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
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!