Skip to main content

Power BI

Needs Votes

Add Microsoft Graph API as a connected service

Vote (472) Share
Jourdan's profile image

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 (23)
Jourdan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:55:35

RE: Add Microsoft Graph API as a connected service

totoc, is there anyone behind this community ? you asked us How can we improve POWER BI. Please improve it by getting back the feature of MS Graph to PBI by ODATA connection. At least connect it with any other flow. It was done with the MS Graph security API, why it cannot be done for the entire MSGraph API as it is for security. note that the feature has been gone for over a year now. and the idea posted for 3 years.

Jourdan's profile image Profile Picture

John Benfield on 05 Jul 2020 23:36:51

RE: Add Microsoft Graph API as a connected service

I wonder if this still works in Tableau :)

Jourdan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:21

RE: Add Microsoft Graph API as a connected service

Can we have an update please? Graph connector was working before June 2018. Waiting for a solution since!

Jourdan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:07

RE: Add Microsoft Graph API as a connected service

Could any PMs give us update on this please ? thx

Jourdan's profile image Profile Picture

Uli on 05 Jul 2020 23:34:09

RE: Add Microsoft Graph API as a connected service

This would be excellent.

Jourdan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:33:55

RE: Add Microsoft Graph API as a connected service

'+1 from me!

Jourdan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:46

RE: Add Microsoft Graph API as a connected service

'+1 from me!

Jourdan's profile image Profile Picture

Nayan Patel on 05 Jul 2020 23:22:43

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!

Jourdan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:28

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

Jourdan's profile image Profile Picture

Kawabata Yoshihiro on 05 Jul 2020 23:19:33

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.