Cannot access SAP BD report data via power query

82 Views

Dear All,

I am new to odata, SAP BD and power queries, but have been trying for some days now to obtain the report data in excel from SAP to no avail, and I am hoping you can help….

If I use the following:

https://myxxxxx.sapbydesign.com/sap/byd/odata

https://myxxxxx.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc

https://myxxxxx.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc/$metadata or

https://myxxxxx.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc/$metadata?entityset=RP<ReportID>Queryresults

then I get the desired results, but the minute I try https://myxxxxx.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc/RP<ReportID>QueryResults

I get a “Web page cannot be found 404” error, or a “Bad command (400)” error….. I have tried adding saml2=disabled to the url, but no joy, apologies for the basic nature of my question, but what am I doing wrong?

Regards

Laura