Microsoft Graph connectivity with Power BI

[amsrivas]

Hi Folks!!

My requirement is to connect Microsoft Graph from Power BI Desktop however i am getting few errors while acheiving this.

Steps :

1. Connect OdataFeed, and provide URL https://graph.microsoft.com/v1.0/.

2. Interface got connected but when i tried to access data for Users Table, it shows below error              

                   

3. Seems, it needs further authentication i.e. Access Token.

Could anyone please let me know how to get rid of this error.

Please suggest!!

Thanks

Amit Srivastava

[lbendlin]

You may want to read up on permissions and consent.  Microsoft Graph permissions reference - Microsoft Graph | Microsoft Docs

[TedPattison]

In order to build a solution with Power BI datasets that extract data from Microsoft Graph API, you really need to create a custom connector. None of the built-in Power BI conntectors will give you the control you need in the authentication process to acquire access tokens with the proper delegated permissions.  

[lbendlin]

Maybe a topic for a future DevCamp?