Forum Discussion
Prompt Page
Hello Everybody,
Is there anything called prompt page like we have in SSRS or Cognos that user can have choices before he sees report output....??
Can we build it using some filter visualizations...??
My advice is this. Don't try to do it the way you have done it in the past with your old systems. Instead think abou the problem and then try to solve the problem with the new tools you have. eg. Problem: User needs to select what the report shows. Solution: you have report filters, slicers, cross filtering etc.
Give it a go with this mind set - you will be amazed.
7 Replies
My advice is this. Don't try to do it the way you have done it in the past with your old systems. Instead think abou the problem and then try to solve the problem with the new tools you have. eg. Problem: User needs to select what the report shows. Solution: you have report filters, slicers, cross filtering etc.
Give it a go with this mind set - you will be amazed.
Hi Matt,
I had a similar request and like to know if there is any Dynamic filtering in PowerBI that gets applied before the Query is fired to DB.
If I don't force the User to select the Parameter values, it first tries to bring more than 100 million rows from SAP HANA DB as my Report contains the DB fields at lowest grain and so if I cannot have dynamic filtering, the Dashboard will not populate even after 24 hours.
Report, Page level and Visual filters gets applied after the data is pulled into the Report or Dashboard and this is as per my understanding of PowerBI.
Please advise.
Thanks,
Nag.
Hi Matt,
I had a similar request and like to know if there is any Dynamic filtering in PowerBI that gets applied before the Query is fired to DB.
If I don't force the User to select the Parameter values, it first tries to bring more than 100 million rows from SAP HANA DB as my Report contains the DB fields at lowest grain and so if I cannot have dynamic filtering, the Dashboard will not populate even after 24 hours.
Report, Page level and Visual filters gets applied after the data is pulled into the Report or Dashboard and this is as per my understanding of PowerBI.
Please advise.
Thanks,
Nag.
The general pattern for Power BI is that you (the report author) should load the data, not the end user. So if you don't want 100 million rows in your report, then write a query that returns less rows. But don't expect the end user to do this. One alternative is to create a template and set up parameters, but personally I am not a fan of that approach.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
