Hi All,
I am trying to consume XSODATA feed with Optional Parameters and I can see the back end response but when I am trying to expose this URL to Microsoft Power BI Basic ODATA feed then I getting the below error and for Web API , It is asking for a key.

The Sample I used was something like this and , it is working in the backend in WEBID perfectly.
http://IP:PORT/PACKAGE/XYZ/ABC.xsodata/COUNT_BACK_LOG_DATA_FEED(IP_WarehouseNumber='EZE1',IP_from_date='20141231',IP_TO_DATE='20191231')/Results
(Validation at the Calculation view level is also added in filter expression as this XSODATA has Calculation View which has Optional parameters.
Kindly let me know , how to consume this XSODATA url in Microsoft Power BI?
@florian.pfeffer : - Please help me out on this one.