Microsoft 365 Usage analytics Dataset refresh issue

[meenakp]

Hi,

One of our global admin is trying to refresh/use the Microsoft 365 Usage analytics report in PBI Service for the first time.

For dataset settings, he chooses his windows account, authentication mode as OAUTH2 and privacy as private.

Dataset refresh fails with error as below. Can you please advise what would be the fix?

“OData: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=true,

….”

Thanks!

[meenakp · Accepted solution]

@v-yuaj-msft, @collinq , Thanks for your responses.

It turned out that hyphens in the tenant id was the rootcause.

Entering tenant id without hyphens resolved the issue.

[v-yuaj-msft]

Hi @meenakp ,

Please check this link if it can help you.

Hope that's what you were looking for.

Best Regards,

Yuna

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

[meenakp]

@collinq, We didn't even try to use this report in PBI Desktop mode.

Since its a standard content, we thought we can just start using it in Service directly [ Just like Usage metrics]. Is it not the case?

Thanks!

[collinq]

Hi @meenakp ,

You can start in Service alone so if that is what you did, then my train of thought will not be pertinent.  Did the link from @v-yuaj-msft  help you?

[collinq]

Hi @meenakp ,

Can you ocnfirm that the same authentication mode and privacy setting is being used in desktop along with the service?

Also, yo ucan review this thread here to see if it helps: Microsoft 365 usage pbit error - Microsoft Power BI Community