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