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.
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |