Forum Discussion

mcolbert's avatar
mcolbert
Regular Visitor
5 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    5 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

  • mcolbert's avatar
    mcolbert
    Regular Visitor

    GilbertQ 

     

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

  • Anonymous's avatar
    Anonymous
    Not 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.

  • 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.