Web service api call convert date parameter to text

[shzyincu]

I am having an issue passing date parameters to a pentaho web service, but when passing parameter as date it says:

Below is the call that is being made to the web service on my local machine.

Parameter name is date_start

Web.Contents("http://localhost:8081/kettle/executeTrans/?trans=E:\pentaho\dashboard.ktr&date_start="&date_start)

We cannot apply operator & to types Text and Date. I can not use data type of the parameter as text as i have used slicer on the dashboard and that parameter is passed as the starting date to it, and it only accepts the date data type param. what should i do with it?

[v-qiuyu-msft]

Hi @shzyincu,

The syntax of Web.Contents() in Power Query is Web.Contents(url as text, optional options as nullable record) as binary. You need to deep into the pentaho web service to check if filter can be passed in URL with this format date_start="&date_start firstly. You can replace the parameter name in URL with a specific date, check if data can be retrieved.

Instead of pass filter in URL, you can also filter the rows when start date column in Query Editor match query parameter values, see: Deep Dive into Query Parameters and Power BI Templates.

Best Regards,
Qiuyun Yu