Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
ksabi

Graph API in Power BI Issue (access forbidden)

Submitted by Advocate II on ‎06-13-2018 05:27 AM

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:

 

Access Forbidden.PNG 

 

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

 

Graph Explorer.PNG

 

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

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎06-13-2018 10:54 PM

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

Vicky_Song
Impactful Individual
Impactful Individual
‎06-13-2018 10:55 PM
Status changed to: Delivered
 
cristianoag
New Member
‎05-28-2020 11:23 AM

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
Employee
Employee
‎06-23-2020 11:07 AM

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%...

Idea Statuses