Making Queries from SAP Odata reports

[CarlsBerg999]

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.

[v-alq-msft]

Hi, @CarlsBerg999 

I'd like to suggest you refer to the following documents to see if they help.

Web connector 

OData Feed connector 

Json 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.