Forum Discussion

crln-blue's avatar
crln-blue
Post Patron
2 years ago
Solved

Odata feed to powerbi with header using basic auth

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.

 

2 Replies