cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlsBerg999
Helper III
Helper III

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 1
v-alq-msft
Community Support
Community Support

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors