Forum Discussion

KRZYSZTOFB's avatar
KRZYSZTOFB
Frequent Visitor
2 years ago

Parameter change on published report

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.