DatePicker for SQL Query

[KRZYSZTOFB]

Hello, 

It's there any possibility to have date picker to import data from SQL server?

In my file I'm using two parameters with date and time in my SQL query.

Best regards

Krzysztof

[v-henryk-mstf]

Hi @KRZYSZTOFB ,

According to your description, when the date parameter is used in conjunction with a PowerBI query, an error message of the following type appears.

We cannot apply operator & to types Text and Date.

Just like below:

The best way is to set the dynamic start date and end date for the date table in Power Query after successfully connecting to the sql data source, the detailed steps can be found in the following blog.

Using A Dynamic StartDate & EndDate For Power BI Query Date Tables (enterprisedna.co)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@KRZYSZTOFB , No , It has table from Power bi Table.

Check if the Dynamic M parameter can help https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

[KRZYSZTOFB]

Hello,

I have created file according to link You have shared.

Filtering works properly but since i've bind my table to parameter, I'm not able to use calendar on slicer. 

I have only two options visible: List and Dropdown:

Field is slected properly - as Date.

Everything was fine before binding.

Do you have idea how to fix this?

Best regards

K.B