Forum Discussion
SAP bydesign integration with PowerBI using odata -The given URL neither points to an OData sevices
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 .
Thank you in advance.
3 Replies
v-danhe-msftMicrosoft Employee
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
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.
While i'm assuming 5 years later you found an answer, for other users - use format=atom instead
