Dataset Parameters Readonly in Service

[mcolbert]

Hey all,

I have a pbix  used as a shared dataset to multiple reports. I had a request to temporarily exclude some data for the report. I added a text parameter where the excluded item codes can be added as a csv list. The parameter is used in PowerQuery to filter out the items.

Works great, and the point was to not have to update the pbix file when the list of excluded items needs to be updated. However, when I view the parameter in the data set settings in the service, the value is read-only. I've been unable to find any critieria that would cause this parameter to be read-only. I have used parameters in the past and had not run into this issue beofre. Any ideas are greatly appreciated.

Thanks

[GilbertQ · Accepted solution]

Hi @mcolbert 

Can you make sure that the data type is set to Text?

If it is set to any I think it will not work.

[mcolbert]

@GilbertQ 

Thanks, I don't usually leave parameters as type Any. But that was it, switched to type text and works as expected. Thanks!

[GilbertQ]

Thanks for letting us know!

[v-eqin-msft · Accepted solution]

Hi @mcolbert ,

@GilbertQ  is right.

And it is supported by official documents that parameters of Any and Binary type aren't editable.

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

[GilbertQ · Accepted solution]

Hi @mcolbert 

Can you make sure that the data type is set to Text?

If it is set to any I think it will not work.