Jourdan on 14 Jul 2016 04:33:00
The Microsoft Graph API (http://graph.microsoft.io) is a unified ODATA endpoint to access data across Microsoft services. More specifically AAD/O365.
There is a major reporting/auditing component of this service as well as other resources being useful to use in Power BI reports.
- Comments (19)
RE: Add Microsoft Graph API as a connected service
This would be excellent.
RE: Add Microsoft Graph API as a connected service
'+1 from me!
RE: Add Microsoft Graph API as a connected service
'+1 from me!
RE: Add Microsoft Graph API as a connected service
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!
RE: Add Microsoft Graph API as a connected service
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
RE: Add Microsoft Graph API as a connected service
Yes, I want it too.
For easy / quick without developer, without learn Odata,
I want the Microsoft Graph as Data Source.
RE: Add Microsoft Graph API as a connected service
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.
RE: Add Microsoft Graph API as a connected service
You could achieve something like this trough CSV:
take a look at this GIT:
https://github.com/eringreenlee/azureb2c-reportingapi
RE: Add Microsoft Graph API as a connected service
'+1