Forum Discussion
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.
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/3458773
TLDR: I made the credentials anonymous and pass authorizations ("Basic " and credentials) and client as a header.
2 Replies
- crln-bluePost Patron
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/3458773
TLDR: I made the credentials anonymous and pass authorizations ("Basic " and credentials) and client as a header.
- metricaPost Prodigy
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.html
A 30-day free trial is available.
Documentation: https://metricasoftware.com/docs/sap/
Cheers,
Metrica Team