Parameter change on published report

[KRZYSZTOFB]

Hello,

I have PowerBi dashboard where i'm collecting data from SQL server by using direct query.

For to select date time period I have two parameters "StartDate" and "EndDate" used in my query.

It's there any way to change parameters on published report?

I was trying to bind parameters to table like tutorial:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

but there is no way to use calendar anymore for my slicer.

It's there any other way that user will be able to change part of sql query on published report?

[v-tianyich-msft]

Hi @KRZYSZTOFB ,

According to the description restrictions of the official documentation, "Any" or "Binary" type parameters work in Power BI Desktop, but we currently don't support them in the service, for security reasons.

Please refer to this official document for details:

Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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