Forum Discussion
Dataset Parameters Readonly in Service
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
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.
- Anonymous5 years ago
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.
4 Replies
- mcolbertRegular Visitor
Thanks, I don't usually leave parameters as type Any. But that was it, switched to type text and works as expected. Thanks!
- GilbertQSuper User
Thanks for letting us know!
- AnonymousNot applicable
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.