Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts,
I have created a parameter to Keep Top N rows, so that the users can see Top N rows of their choice.
This is how I defined the parameter.
And updated the M query as
#"Kept First Rows" = Table.FirstN(My_Table,NumberOfRows)
I published the report to PBI service, it is working fine for me. I am able to pass different values and report is displaying Top N rows based on the paramater value passed.
However, when other users (who have access to workspace) try to change the parameter it is coming disabled.
How can other users also able to change parameter value, any other settings need to be enabled?
Please advise.
Thanks.
Hi @Anonymous ,
"Any" or "Binary" type parameters are not supported in the service for security reasons. Users will need edit permission to the dataset.
Best Regards,
Jay
Thanks @v-jayw-msft for youe response. Type is given as Decimal, I unerstand Any and Binary are not supported. Have given access to dataset also, but no luck.
This setting is only available to those who have full access to modify the dataset. Just being part of the same workspace doesn't necessarily give this access.
To me, this seems like a strange way to control what your report shows. You can adjust how many rows are displayed without needing to refresh the entire dataset and modify what everyone else sees too.