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.

[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.