Power BI and Office Graph

[edumarcos]

Hi everyone,

Does anyone knows if it is possible to use Power BI with Office Graph? I would like to call Office Graph from Power BI Dashboard.

Thank you in advance!!

[Sokon]

I succeeded in connecting to Microsoft Graph by using the ODATA standard connector like this:

Enter the following URL (if you want to query other things than users, change string accordinglingly):

Choose "Organizational Account" and log in:

Click Connect:

The tenant you will get the information from seems to be the user's home tenant.

Hope this helps!

[dennis-skymill]

This solution no longer works. Can it be reopned or do I need to create a new question?

[Sokon]

I still get the notification 

Your are right, it stopped working some time ago. Our experts tell me that Microsoft probably doesn't allow Power BI Desktop to access the API any more. We didn't succeed in fixing it and now get the data from another source.

[edumarcos · Accepted solution]

I answer myself, it is possible to connect PowerBI with Microsoft Graph and get some data.

Anyone has ever tried to connect to MS Graph? I can only do a request for simple methods, and when I try to query or try other methods like get user events, I get an access error: "the user was not authorized".

Do I need to configure some permission for Power BI related with Azure AD or Microsoft Graph through the Azure Portal?

Thank you in advance 🙂

[PatrickJLee]

Sorry, but this is not a Solution.  You haven't said how you managed to connect to Office Graph (do you mean Microsoft Graph by the way), and you've also said that you experienced some problems connecting.  

I too would like to know how one is supposed to connect view Microsoft Graph data in Power BI - does anyone know please?

[edumarcos]

Hi everyone,

Does anyone knows if it is possible to use Power BI with Office Graph? I would like to call Office Graph from Power BI Dashboard.

Thank you in advance!!