Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago

Making Queries from SAP Odata reports

Hi,

 

I'm querying data from SAP Business ByDesing reports. Basically you create a report (="pivot table") and import this to PowerBI through an URL.  The URL looks like this: 

 

myXXXXXX.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPZ2321FC51ED9EE5457F43ECQueryResults?$format=atom&$select=CDOC_INV_DATE,CDPY_BUYER_UUID,CIPR_REFO_CATCP,CIP_SALES_UNIT,FCITM_GR_AM_RC,FCZ0COUNT,TDPY_BUYER_UUID,TIPR_REFO_CATCP

 

What you can spot from the URL is that there is $format=atom. I'm in the understanding that this is XML. 

What you can also choose is to put in $format=JSON. 

 

Now for the question: As this is an URL to an Odata, should I in fact use PowerBI Get Data from Odata Feed or is it more suitable to select From Web (as this is an URL, right?) or if i choose the format to JSON, should i query it From JSON?

 

I'm at a loss in a way that I do get the results to work as an OData feed when it is formatted as Atom. But can or should i use the JSON or Web in some situations...?

 

Thanks for the clarification, I'm just looking to confirm that I'm making the import to PBI in the correct way.

1 Reply