Forum Discussion
Solved
Allow users to Modify parameters in PowerBI Server
Hello everyone, I'm moving several reports built from SSRS, which are paginated reports in PowerBI, to a regular PBIX file. These Paginated Reports use multiple stored procedures, and I used them...
What is the business value of allowing them to set the parameters? Would you be better off including all the data and then having the users filter it as needed? Re-rendering in the "regular" Power BI is cheaper than in paginated reports.
The only way is to use Direct Query and Dynamic M Query parameters. But that also involves having all data "at their fingertips".
That's what I thought. Do you believe what I proposed here (LINK) is possible and a good workaround?
Meh? Why go through all that hassle when the Semantic Model can do the work for you?