Forum Discussion
Input value parameter not working
Sampling occurs when too many values are in the column used in parameter. It is a known issue. Unfortunately, it hasn't been addressed yet
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3cd3bbbc-7589-4696-b7f8-e0f1d08b3c42Alternatively, you can add a text column to the table and use that in a dropdown slicer instead. Just make sure to sort it by the original parameter column.
Performance on large sets (10 million in this case) is not always reliable.
Do you need every value seperate or could you use the Step feature to reduce the number of rows.
Hi Sam, unfortunately i need every possible value. I am querying a very large database from Snowflake and the parameter will be used to parametrize the Sql query received by power query.
The report has to be in direct query mode and because of the size of the data model the parametrization is necessary. Build a table with a Text column and materialize upfront all possible values is creazy for me. This makes the model much heavier with many useless MB of data inside.
I am shocked by Microsoft that a Text column is the only solution or workaround.
