Odata feed to powerbi with header using basic auth

[crln-blue]

Hello,

I'm trying to get data from the odata feed from a sap source but it seems like it isn't working because it requires that the client should be stated in odata link. But powerbi ignores the part of the link where the client is stated in the form: <odata url>/?sap-client=310.

So I decided to make a blank query and get data through the odata feed.

below is my m query:

let

url = <my odata url>
Source = OData.Feed(url, [Headers = "sap-client=310"])

in
Source

However, this doesn't work and prompts to make my connection anonymous. But my odata url requires basic auth credentials in order to show the data.

What would be the correct way to proceed with this? 

Thank you very much.

[metrica]

Hi @crln-blue,

You can pass the SAP client in the second argument of OData.Feed:

OData.Feed(url, [#"sap-client" = "310"])

Use Basic authentication in Power BI instead of storing the Authorization header in M code.

For supported SAP S/4HANA environments, Power BI Connector for SAP can centralize SAP authentication and sap-client through a BTP Destination: https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.htm...

A 30-day free trial is available.

Documentation: https://metricasoftware.com/docs/sap/

Cheers,
Metrica Team

[crln-blue · Accepted solution]

This is related to my other question on the Desktop forum so I'll paste the link here: https://community.fabric.microsoft.com/t5/Desktop/Can-t-connect-to-SAP-Odata-Feed-in-Power-BI/m-p/34...

TLDR: I made the credentials anonymous and pass authorizations ("Basic " and credentials) and client as a header.