Forum Discussion
Anonymous
1 year agoNot applicable
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...
Anonymous
1 year agoNot applicable
Hi Rohit,
Thank you for your reply.
I have tried all the options mentioned above,
- 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
- 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.