24 Comments
- You could achieve something like this trough CSV: take a look at this GIT: https://github.com/eringreenlee/azureb2c-reportingapi
- I agree that the powerbi REST API should be extended to provide 3rd party direct access to the data. Just like you can right-click download, you should also be able to access the data via ODATA via some appropriate end-point(s)? If this is through the graph API then so be it. This would be really helpful for governments and public bodies to quickly be able to publish their data (at least in an experimental capacity) by authoring an appropriate PowerBI report.
- Yes, I want it too. For easy / quick without developer, without learn Odata, I want the Microsoft Graph as Data Source.
- ZappySys has released Drivers for REST API (JSON / XML / SOAP). Using these drivers you can connect to virtually any API service in Power BI. It comes with many advanced options such as OAuth Token, Pagination, Error Handling , Query Editor and many more. See below links. https://zappysys.com/blog/howto-import-json-rest-api-power-bi/ https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/ For some concepts of reading Office 365 data (OData API) check this Blog. Its written for SSIS but UI and Settings are same for REST API Driver. https://zappysys.com/blog/calling-office-365-api-using-ssis-graph-api-mail-calendar-contacts-onedrive-excel/ Hope this helps!
- We need Graph API connector for Power BI badly. Currently there is no working way to access Azure AD from Power BI. After Microsoft broke OData connector two weeks ago, we can't use OData to connect to Graph API anymore
- '+1 from me!
- '+1 from me!
- This would be excellent.
- Could any PMs give us update on this please ? thx
