Issue with authentication - Odata Feed to serviceM8

Hi stan_w_gifford,

This issue occurs because Power BI supports only one authentication method per data source, and built-in options like Basic authentication automatically handle the Authorization header. On the other hand, Web.Contents lets you add custom headers for manual authentication. Since ServiceM8 requires both Basic authentication and an API key header, this can create a conflict with Power BI’s authentication model. To resolve this, use Anonymous authentication and manually add both the Authorization and x-api-key headers in Web.Contents, as recommended by Microsoft for header-based authentication scenarios.

Power Query Web Connector - Power Query | Microsoft Learn

Web.Contents - PowerQuery M | Microsoft Learn

Handling authentication for Power Query connectors - Power Query | Microsoft Learn

Tutorial: Integrate Power BI with key phrase extraction - Foundry Tools | Microsoft Learn

Thank you.