Others

How to Fix Microsoft 365 Usage Analytics OData Credential Errors in Power BI

Camila Milosovich Sep 28, 2026 869 views

Question details

Users are encountering a credentials error when attempting to connect Power BI to the reports.office.com OData feed.

Fixing Microsoft 365 Usage Analytics OData Credential Errors in Power BI

Product: Power BI, Microsoft 365
Device & OS: not provided
Scenario: Configuring Microsoft 365 Usage Analytics data sources within Power BI Desktop.
Observed behavior: Power BI displays a credentials error for the reports.office.com OData source, even when the user signs in using an active Global Administrator account.

Before you start

Verify that your Global Administrator account is fully active and check that you are running the latest version of Power BI Desktop before troubleshooting the connection.

Solution 1Recommended

Clear Data Source Permissions and Consult the Power BI Community

Since this is an authentication issue specific to Microsoft's OData feeds and Power BI, clearing cached credentials can sometimes resolve the issue; otherwise, specialized help is required.

Power BI often caches outdated credentials that can interfere with new connection attempts to reports.office.com. Clearing these global permissions forces Power BI to prompt for a fresh authentication token. If the issue persists, it requires escalation to Microsoft's specialized community.

Clear existing data source permissions

Open Power BI Desktop, click on 'File' > 'Options and settings' > 'Data source settings'. Locate 'reports.office.com' in the global permissions list, select it, and click 'Clear Permissions'.

Re-authenticate using Organizational Account

Attempt to connect to the OData feed again. When prompted for credentials, ensure you select 'Organizational account' (not Basic or Windows) and sign in with your Global Admin credentials.

Post in the Microsoft Power BI Community

If the error continues, navigate to https://community.fabric.microsoft.com/. Create a new support topic including your tenant configuration, Power BI version, OData URL, authentication method, and the complete error message.

Account Privileges: It can take up to 24-48 hours for administrative permissions to fully propagate in Microsoft 365 if the Global Administrator role was recently assigned.

Free Microsoft Office alternative

Looking for a Lightweight, Everyday Office Suite?

While complex business intelligence dashboards require specialized tools like Power BI, your daily documentation and spreadsheet tasks don't have to be complicated. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office for creating, analyzing, and presenting your data.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install the Suite: Run the downloaded setup file and follow the on-screen instructions to complete the installation.
3. Start Analyzing Data: Open WPS Spreadsheet to easily import, format, and analyze your exported reports with familiar tools.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Powerful built-in spreadsheet functions for fast, offline data analysis.Lightweight installation with lightning-fast startup times.All-in-one tabbed interface to manage documents, spreadsheets, and PDFs effortlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does reports.office.com reject my Global Admin credentials in Power BI?

This typically happens if Power BI is attempting to use an incorrect cached token, if the 'Basic' authentication method was accidentally selected instead of 'Organizational account', or if your tenant lacks the necessary Microsoft 365 usage analytics prerequisites.

What authentication method should be used for Microsoft 365 Usage Analytics?

When prompted for credentials for the reports.office.com OData feed, you must always select 'Organizational account'. Using 'Anonymous', 'Windows', or 'Basic' will result in credential errors.

Does WPS Office support Power BI data integrations?

WPS Spreadsheet provides excellent offline data analysis and visualization tools. While direct OData feeds to Power BI are native to Microsoft's ecosystem, you can easily export your WPS spreadsheets to CSV or XLSX formats, which can then be imported directly into Power BI.

Can I use a Reports Reader account instead of a Global Admin?

Yes, Microsoft allows users with the Reports Reader role or the Exchange Administrator role to access Microsoft 365 Usage Analytics data without needing full Global Administrator privileges.

Office Quick Solutions