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: 

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

jevgenijmart

Error getting OData from Microsoft Graph: Access to the resource is forbidden

Submitted by on ‎06-01-2018 01:37 AM

Hello,

 

I am getting an error "Access to the resource is forbidden" when trying to access Microsoft Graph in Power BI Desktop report.

Microsoft Graph URL is https://graph.microsoft.com/v1.0/devices

I am logging in using Organization Account.

I have Global Admin role in the tenant.

 

The report was working normally for months, but stopped since yesterday.

I even tried creating new one - same result.

Accessing the same URL from Graph Explorer works fine.

 

What could actually impact this kind of error?

Status: New
See more ideas labeled with:
38 Comments (38 New)
Comments
bartekab
Regular Visitor
‎06-18-2018 11:25 PM

I see that today another update to PowerBI was implemented yesterday – since today there is no oAuth authentication available at all – it was just yesterday. oAuth.png

Anonymous
Not applicable
‎06-19-2018 06:23 AM

@bartekabThere's already multiple duplicate ideas for this.

 

I believe this one currently has the most votes; we should consolidate to that one:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15198333-add-microsoft-graph-api-...

 

PG03
Frequent Visitor
‎07-06-2018 11:56 AM

I believe this is still a problem - correct?

 

This problem even contradicts MS's own documentation on customizing the Office 365 Adoption content pack.  https://support.office.com/en-us/article/customize-the-office-365-adoption-content-pack-9b76065f-29b...

 

You can no longer customize the reports following their instructions, recieving this very error message when attempting to load the data.

 

 

 

How MS thinks crippling one of their solutions from another MS solution is a good idea is beyond me.

 

Power Bi should be the default reporting engine for any MS service without question.

OneWithQuestion
Post Prodigy
Post Prodigy
‎09-12-2019 12:57 PM

Has anyone found a good way to connect to Graph API?

GMMarin
New Member
‎03-04-2020 10:13 AM

@jevgenijmart Did you find a solution/workaround?

Lucindo
Microsoft Employee
Microsoft Employee
‎06-23-2020 11:13 AM

Hi I've created a step-by-step guide to deploy a custom connector that I’ve developed using the Power Query SDK. Maybe this can help you!

ChrisAtMAF
Frequent Visitor
‎12-03-2020 09:20 AM

I found @Anonymous and @jevgenijmart had something that would work well, in a way that doesn't require someone to install Visual Studio or create a custom connector.

 

The guide is here - hope it helps someone else out!

https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

Idea Statuses