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:
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?