Organazation Authentication Issue - Application not found in tenant

[SankethContoso]

I have a PoweBI report .pbix file, for which the data source is Odata feed from "https://reports.office365.com". My requirement is to generate Office 365 Security and Complaince reports like MailTraffic, MailSpam etc..

I have multi factor authentication enabled for my accounts.

Hence if i have to use Basic authentication, then i should be using app passwords, (works fine). But in another tenant since apppasswords tab is hidden, i should login via Organization Account.

When i try to authenticate using Organzation account, i receive the below error.

invalid_resource: AADSTS500011: The resource principal named https://reports.office365.com was not found in the tenant named 1f39519c-ca2a-4243-8de4-5de2c7b948d1. This can happen if the application has not been installed by the administrator of the tenant or consented to by any user in the tenant. You might have sent your authentication request to the wrong tenant.
Trace ID: 18de582f-0559-4499-89fa-118b1403c700
Correlation ID: 6ade3c8f-24a8-4a2c-8d11-a9d6eba84d76

I tried to debug by checking Azure AD sigin logs. The status was Failure with Error code 500011 (this error code is not present in microsoft docs 

https://docs.microsoft.com/en-us/azure/active-directory/reports-monitoring/reference-sign-ins-error-...)

Also the log had application id and name which is 

Application:  Microsoft Power Query for Excel

Application ID: a672d62c-fc7b-4e81-a576-e60dc46e951d

This application Id is only present as Enterprise Application in Microsoft tenant. 

How can my tenant access this resource, so that my powerBi reports loads the data??

[v-lid-msft]

Hi @SankethContoso ,

Have you tried to change the tenantid in the odata url? It seems like the error occor in the Tenant 18de5...3c700, but the odata tring to connect the tenant 1f395...948d1. You can change the odata feed address in the Anvanced Editor of Power Query Editor. Please refer to this document about connect the the reports in Microsoft 365 usage analytics: https://docs.microsoft.com/en-us/office365/admin/usage-analytics/customize-reports?view=o365-worldwi...

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SankethContoso]

Hi,

I tried generating reports from the link provided and they donot provide me all the information what i need.

Mainly i am trying to get Exchange Online Mail protection report similar to the dashboard in Office 365 Admin center -> Reports

i found a BLOG   which i followed as per the steps mentioned and works fine with basic authentication..

Also https://reports.office365.com/ecp/reportingwebservice/reporting.svc/ gives much more information which is what i need to achieve with organization account authentication.