Power BI Connectivity with Microsoft Graph with Token

[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, 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

[v-janeyg-msft · Accepted solution]

Hi, @amsrivas 

You can directly use powerbi connector. Reference:Connect to the Microsoft Graph Security API in Power BI Desktop - Power BI | Microsoft Docs

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amsrivas]

Hi,

Via Power BI Connector, i am not able to access tables such as Users etc.

Thanks

Amit

[v-janeyg-msft]

Hi, @amsrivas 

Have you successfully signed in? Can you share a screenshot that you can’t access?

Best Regards

Janey Guo

[amitchandak]

@amsrivas , refer if this old solution can help

https://community.powerbi.com/t5/Desktop/Use-Microsoft-Graph-API-as-data-source/m-p/640426

[amsrivas]

Hi @amitchandak 

There is no link under Tutorial to follow, is there any other way.

Does this require ADMIN ACCESS to use Access Token while connecting Power BI to Microsoft Graph. 

Thanks

Amit