Forum Discussion

edumarcos's avatar
edumarcos
New Member
9 years ago
Solved

Power BI and Office Graph

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!!
  • edumarcos's avatar
    edumarcos
    9 years ago

    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 :)

Sokon's avatar
Sokon
Advocate V
9 years ago

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's avatar
dennis-skymill
New Member
7 years ago

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

  • Sokon's avatar
    Sokon
    Advocate V
    7 years ago

    I still get the notification :smileyhappy:

    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.