Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!!
Solved! Go to 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 🙂
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!
This solution no longer works. Can it be reopned or do I need to create a new question?
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.
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 🙂
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?
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!!