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

    Nicky van Vroenhoven on 02 Jun 2021 09:31:23

    RE: Add Microsoft Graph API as a connected service

    Yes, this would be very, very helpful!

    Jourdan's profile image Profile Picture

    Christian Villegas on 06 May 2021 16:11:16

    RE: Add Microsoft Graph API as a connected service

    Please we need licenses and sku counts and we have to make external calls and save the data to OneDrive using PS or AZ SQL and it's just inefficient to save it. I don't know why this was removed.

    Jourdan's profile image Profile Picture

    David Král on 10 Dec 2020 06:56:16

    RE: Add Microsoft Graph API as a connected service

    This is really needed. Hard to believe it was not switched off intentionally.

    Jourdan's profile image Profile Picture

    Chris Hill on 03 Dec 2020 17:24:26

    RE: Add Microsoft Graph API as a connected service

    I am also struggling with this lack of functionality, but have managed to found a way around at least some of the problem - hope it help others!

    https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

    Jourdan's profile image Profile Picture

    M P on 06 Jul 2020 00:13:54

    RE: Add Microsoft Graph API as a connected service

    Have there been any developments on this since the last comment (December 2019)?

    Jourdan's profile image Profile Picture

    Adam Lietzau on 06 Jul 2020 00:04:38

    RE: Add Microsoft Graph API as a connected service

    I don't know how this isn't an official connected service. I can pull data from Graph to PowerBI using a custom connector, but then I'm only limited to 100 results at a time. If I want to pull things like mailboxes, I have to run the connector for each 100 results and authenticate each time. This isn't a realistic solution!

    Jourdan's profile image Profile Picture

    David Blancard on 05 Jul 2020 23:59:00

    RE: Add Microsoft Graph API as a connected service

    PLEASE ADD THIS!!!

    Jourdan's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:58:57

    RE: Add Microsoft Graph API as a connected service

    This would be EXTREMELY helpful, please add it

    Jourdan's profile image Profile Picture

    Brian T on 05 Jul 2020 23:56:50

    RE: Add Microsoft Graph API as a connected service

    Please get this added in the next release. I've got to find a means to report on identity risk data and we are your strategic partner. I will also be reaching out via account executive.

    Jourdan's profile image Profile Picture

    Håkon Wøien on 05 Jul 2020 23:56:34

    RE: Add Microsoft Graph API as a connected service

    '+1