Forum Discussion

giorgiokatr's avatar
giorgiokatr
Icon for Helper V rankHelper V
9 years ago

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's avatar
    PavelR
    Icon for Solution Specialist rankSolution 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's avatar
      giorgiokatr
      Icon for Helper V rankHelper 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's avatar
        PavelR
        Icon for Solution Specialist rankSolution 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

  • 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's avatar
      giorgiokatr
      Icon for Helper V rankHelper 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's avatar
        Baskar
        Icon for Resident Rockstar rankResident Rockstar

        Do u have Custom visual in your page ?