Forum Discussion
giorgiokatr
Helper V
9 years agoMany 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 s...
tringuyenminh92
Memorable Member
9 years agoHi giorgiokatr,
I would like to continue with Anonymous'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.
- giorgiokatr9 years ago
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...
- Anonymous9 years agoNot applicable
Do u have Custom visual in your page ?
- giorgiokatr9 years ago
Helper V
Yes I have 3
Liquid fill qauge
Hierarchy slicer
Card with states