SAP bydesign integration with PowerBI using odata -The given URL neither points to an OData sevices

[Anonymous]

Hi All,

I am trying to integrate SAP bydesign with power BI.But its failing with below error

OData: The given URL neither points to an OData service or a feed

Odata feed-

https://<my server name>/sap/byd/odata/ana_businessanalytics_analytics.svc/RP<Report ID>QueryResults?
$select=CSTATUS_LIFE_CYCLE_STATUS_CODE,CID_CONTENT,KCOPEN_QUANTITY&$filter=(CSTATUS_LIFE_CYCLE_STATUS_CODE%20eq%20%271%27)&$top=10000&
$format=json

Authentication-Basic with business user account

I referred below thread but its not working .

https://community.powerbi.com/t5/Desktop/OData-The-given-URL-neither-points-to-an-OData-service-or-a...

Thank you in advance.

[AlannahNgaire]

While i'm assuming 5 years later you found an answer, for other users - use format=atom instead

[v-danhe-msft]

Hi @Anonymous,

Based on my research, could you please refer to below link to test if your data could be loaded into the power query:

https://blogs.sap.com/2015/10/07/using-sap-bydesign-odata-in-microsoft-power-query/

Regards,

Daniel He

[Anonymous]

Hi ,

Thank you @v-danhe-msft.

I tried the url in Power query as well.Getting same error.Alos I am not getting "Standard authorization " option when I enter the URL.