Skip to Content
Former Member
Aug 17, 2017 at 08:45 AM

Cannot access SAP BD report data via power query


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:$metadata or$metadata?entityset=RP<ReportID>Queryresults

then I get the desired results, but the minute I try<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?