Skip to Content
0
Jun 19, 2020 at 12:49 PM

XSODATA with Optional Input Parameters URL gives error when consumed in POWERBI

92 Views Last edit Jun 19, 2020 at 08:14 AM 2 rev

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.

Attachments