Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Thanks, I don't usually leave parameters as type Any. But that was it, switched to type text and works as expected. Thanks!
Thanks for letting us know!
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.