Powerbi - Graph.microsoft.com

[pdesmarais]

Im trying to get details in PowerBI from the Graph API, im able to connect, but the data return is always empty?

I need a lot of Graph info just like this secure score
https://graph.microsoft.com/stagingBeta/reports/getTenantSecureScores(period=1)/content
DataFormat.Error: OData: The given URL neither points to an OData service or a feed: 'https://graph.microsoft.com/stagingBeta/reports/getTenantSecureScores(period=1)/content'.
Details:
https://graph.microsoft.com/stagingBeta/reports/getTenantSecureScores(period=1)/content

Issue: Examples return just a 3bytes files.
let
token = "eyJMX1",
Source = OData.Feed("https://graph.microsoft.com/v1.0/reports/getOneDriveUsageAccountDetail(period='D7')", null, [Headers = [Authorization = "Bearer " & token] ])
in
Source


This one Works:
let
token = "eyJMX1",
Source = OData.Feed("https://graph.microsoft.com/v1.0/users", null, [Headers = [Authorization = "Bearer " & token] ])
in
Source

[v-chuncz-msft]

@pdesmarais,

You may take a look at link below.

https://stackoverflow.com/questions/48708196/getting-microsoft-graph-api-report-data-into-power-bi-u...

[pdesmarais]

This doesn't work.

Everything is getting out of Office 365 Report to Graph.Microsoft.Com and nobody can make it work in PowerBI

Do you have a sample file or real article that is recent enough.

In powershell everything works like magic, my Token is working, etc.

Powerbi Desktop and Services Fails