Forum Discussion
Many pages vs one page
I have a big report with many visuals and numbers
it is splitted in 5 pages
in every page i have the same filters at top. Its disturbing that filters are not report level and i have to select the same filters five times for each page.
so i decided to merge all 5 pages to a big one page (i changed dimensions to 1280*5000) just to check
But report now is very slow and in service my browser is laggy or sometimes not responding.
Is it normal?
11 Replies
- PavelR
Solution Specialist
Hi giorgiokatr
what about using Report level filter on the right pane? Even though the filters would be in default view not visible (won't be on the page), but the selection would be used across all 5 pages.
Regards.
Pavel
- giorgiokatr
Helper V
These filters are a solution indeed. However slicer for example is much more flexible! Also report level filters are not available in mobile app. Thanks! I think that creating such a huge page I pushed pi or browser to its limits..!- PavelR
Solution Specialist
You are welcome giorgiokatr. Yeah I agree with you, that slicer would be much more suitable if they have the ability to be used across all pages.
Regards.
Pavel
- tringuyenminh92
Memorable Member
Hi giorgiokatr,
I would like to continue with Baskar's suggestion but with a little bit difference that you need to clarify that the lagging is coming from rendering layer or data transfering layer.
- Cause render layer:
- if the root cause is render layer of charts control or PBI service that could not handle your amount of data, we could ask some staffs to check service again or raise ticket to MS for improvement.
- Check and optimize your calculated measure/column
- if the root cause is from data transfering, we need to clarify:
- With Importing mode, there will be a lagging or short delay each refreshing time cause your data is huge. And you don't need to care about limitation of 10GB, cause as my observation, we could add more space for tenant users by buying more tetnants and shift their space to your account. but you need spend time to optimize your data model and DAX expression. Please refer this topic and another topic of sqlbi.com cause i found there some good optimize topics in there (refer topic for optimize tabular model same as for power bi)
- With Direct Query, you need to check your server side again cause the response time will depend on computing power of your server side or your index of db.
And the last note that we should optimize whenever we can, don't wait to huge or bigdata.
Hope you provide more information as above description so we could help you in specific case.
- giorgiokatr
Helper V
Thanks my pbix is 7 mb.
My dataset is 17.000 rows through sql server (import method)
i have 3 calculated columns and about 20 measures.
i think its render problem beacause i have in one page about 60 visuals.
firefox says a script stopped responding...
- Baskar
Resident Rockstar
Do u have Custom visual in your page ?
- Cause render layer: