Forum Discussion
Helper IVconnect power bi to Microsoft graph api
hello
i would like to know how can i do to connect power bi to microsoft graph api simply
i would like to create report in wich i display the number of emails sent or received before 7:00 am and display number of meeting for each user.
i have tried to use the odata connection by using this url: https://graph.microsoft.com/v1.0 and using admin connection but i obtainded access denied to the ressource!!!
is there any other solution to create this kind of report
thank you in advance
4 Replies
- mahoneypat
Microsoft Employee
It is not easy to get Graph data with Power BI. It is frustrating. Here is a post that describes how.
https://community.powerbi.com/t5/Power-Query/Running-Graph-API-queries/td-p/750446
However, since you are getting email data, you can just use the Exchange connector with your microsoft account and choose the Mail table.
Regards,
Pat
- amitchandak
Super User
SLI , You can refer what has been suggested by mahoneypat .
some additional resource
https://blog.mydock365.com/microsoft-graph-api-data-on-microsoft-power-bi
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-graph-security
SLIthank you for your answer but your solution does not resolve my problem
what i want to do is to get the calendar and meetings of users, so, the graph security connector is not ok for me
the once url : https://graph.microsoft.com/beta/users also does not works
is there other solution? by using Azure for example
thanks
Hi SLI,
It seems like odata connector with graph api not works, have you try to use web connector and rest api?
Microsoft Graph REST API v1.0 reference
Pull data from a REST API Authentication
Regards,Xiaoxin Sheng
