The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
36 | |
24 | |
23 | |
21 | |
16 |