Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
2 years ago
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...
"DAX help"
@datasets
Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Meh?  Why go through all that hassle when the Semantic Model can do the work for you?

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
2 years ago

Oh really? Do you have any walkthroughs on this? It would be helpful to see how can achieve it using Semantic Models

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    As I said - load all the data, and then let the users look at it and filter as needed.  Let go of the urge to try and control the rendering.