Forum Discussion
Prompt Page
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.
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.