Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Error while connecting to SAP Datasphere Analytic model via OData API

WE are getting the below error while connecting SAP Datasphere via Odata URL:   Could you please help us resolve the issue, as we are getting the data in web by running the URL but getting th...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

hi Anonymous ,

Try these steps to fix the issue:

  1. Check URL Format – Ensure it's a valid OData v4 service. Open it in a browser and verify it returns JSON/XML metadata.
  2. Authentication – Use Organizational Account or Basic Auth in Power BI.
  3. Connection Mode – In Get Data → OData Feed, test both Anonymous and Organizational authentication.
  4. Test Endpoint – Append ?$format=json or ?$metadata to the URL in a browser to verify OData support.
  5. Whitelist Power BI IPs – Ensure SAP Datasphere allows connections from Power BI.