Forum Discussion

julsr's avatar
julsr
Continued 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
Super User
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.

  • julsr's avatar
    julsr
    Continued Contributor
    2 years ago

    My client was using paginated reports to consume all the data from their database, allowing Business Users to filter as they wanted and download it as an Excel file. So, the next step is to see if we can replicate this usage using PBIX files, and for sure, what's expected in the future is to do it as you mentioned. 

    So, for now, I want to see if it is possible to allow users to modify parameters in an easy way.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      The only way is to use Direct Query and Dynamic M Query parameters. But that also involves having all data "at their fingertips".

      • julsr's avatar
        julsr
        Continued Contributor
        2 years ago

        That's what I thought. Do you believe what I proposed here (LINK) is possible and a good workaround?