Working with Odata feeds

[CarlsBerg999]

Hi,

Im working on getting SAP ByDesign Odata feeds to Power BI. Basically i put the URL in Power BI OData feed:

https://myNNNNNN.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPCRMCIVIB_Q0001Q...

According to my understanding, the URL has a standard structure. At the end there seems to be "Select" after which the wanted columns are chosen. Where can i learn to modify this feed or is it just the same as modifying the query in the Power Query editor?

Basically im intrested in making more sophisticated queries and im not quite sure if its smarter to edit the URL to some extent and then continue with the Power Query editor.

Advices or tips?

Thanks in advance! 

[lbendlin]

how many columns and rows are in the raw feed? Would your ODATA filtering be only for fun, or would the web call not work without it?

You may want to ask your SAPByDesign team for the documentation of the ODATA feed.