Forum Discussion
Solved
Use Microsoft Graph API as data source
Dear Community, I received a task to create a report about all free meeting rooms at a given time. As far as I can see, this can be achieved by accessing all shared calendars via the Graph API: ...
The Microsoft Graph implements the OAuth 2.0 authentication flow and therefore, to access it with Power BI, you'll need to create a custom data connector. Here's a tutorial that walks step-by-step on how to create a custom data connector with OAuth 2.0 to the Microsoft Graph in Power BI.
tonmcg
Resolver II
Resolver IIThis should be the accepted answer. Extremely thorough tutorial that allows Power Query (Power BI, Excel, etc.) to interact with the Microsoft Graph API. Bravo!
(Now, all it needs is a way to decrypt that client secret. )
HairyDrumroll
Advocate I
Advocate I
tonmcg wrote:This should be the accepted answer.
Except that it doesn't work for Delegated Permissions, which is what you need to be able to read the Microsoft ToDo data.