Error while connecting to SAP Datasphere Analytic model via OData API

[soniaparvin9]

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 this error while connecting from Power BI.

[soniaparvin9]

Hi Rohit,

Thank you for your reply.

I have tried all the options mentioned above,

1. Check URL Format – Ensure it's a valid OData v4 service. Open it in a browser and verify it returns JSON/XML metadata: It is returning data of the DS analytic model
2. Authentication – Use Organizational Account or Basic Auth in Power BI : Basic we can log in with DS credentials but for organizational account getting the below warning

3. Connection Mode – In Get Data → OData Feed, test both Anonymous and Organizational authentication. : getting the same error

4. Test Endpoint – Append ?$format=json or ?$metadata to the URL in a browser to verify OData support. : getting the same error after appending 

5. Whitelist Power BI IPs – Ensure SAP Datasphere allows connections from Power BI:

Added the IP of the power BI system in Datasphere IP allow list, still got the same error.

[rohit1991]

hi @soniaparvin9 ,

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.