Graph API in Power BI Issue (access forbidden)

[ksabi]

Hello,

I generally use Power BI to import users using the Graph API  https://graph.microsoft.com/v1.0/users

Some days ago, I noticed that the API is not working any more. When I try to create a new OData feed I get this error:

 

But, on the graph explorer,  my account allows me to run the query and get the result as shown below:

Is there a modification concerning the OData feed access in Power BI?

Did someone else face the same problem?

Thank you in advance for your help.

Regards,

KSABI

[v-qiuyu-msft]

Hi @ksabi,

The same issue has been reported before internally: CRI 71609700. Please see below information from PG team: 

We do not support connecting to Graph. Because of various auth challenges, generic OData connectivity does not work. Users should vote for a dedicated Graph connector on UserVoice(https://ideas.powerbi.com/forums/265200-power-bi-ideas) to register their interest.

Best Regards,
Qiuyun Yu

[cristianoag]

Hi @ksabi. I documented an approach to have Power BI consuming Graph data. There is a workaround using explicit app authentication for the operations that support that and a custom connector for the ones that only support user/delegated permissions. More details available at https://techpeanuts.wordpress.com/2020/05/28/connecting-power-bi-to-microsoft-graph/ 

[Lucindo]

In addition to you @cristianoag, I've created an english version for my step-by-step guide: https://github.com/JoaoLucindo/DataConnectors/blob/master/samples/Planner%20Connector%20-%20Gateway%...

[Anonymous]

There are 2 UserVoice Ideas related to this that need your votes.

https://ideas.powerbi.com/ideas/idea/?ideaid=84fb5246-8859-4c85-a20a-93a1fa81cd75
https://ideas.powerbi.com/ideas/idea/?ideaid=79adc30e-dc3f-427e-9ece-bd31c97137a4