Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago

Table Visual Taking Too Long to Load

Hello,

 

I have a report with ~ 15 million rows and about 50 columns. I need to create a report with a table visual that shows this data and lets a user export the data to Excel. This visual cannot be summarized. When I try to load this report in Service, the visual takes close to two minutes to load, or just doesn't load with an ran out of resources error. 

 

What can I do so this table visual loads faster? I'd appreciate any help!

Need Help

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    Hi newpbiuser01 

    your dataset might needs some attention and optimization. It could also be from a measure used in that visual that needs optimization.

     

  • newpbiuser01's avatar
    newpbiuser01
    Helper V
    2 years ago

    Hi aj1973,

     

    Sorry, just to clarify, there are no measures being used in the table visual. Also, this isn't in just one report. I have had it on multiple data tables where we have the export table visuals. How would you recommend I optimize it? I've already removed/deleted all columns that aren't needed in the table visual and also created a star schema with dimension tables so all the columns are not just coming from the large data table. 

    I tried not having the dimension tables to see if that would help - same issue. 😞

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Columns with long strings like long comments can also put pressure on the work load. Combination of multiple tables as well and therefore denormalize some of them could help... Also many visuals in a same page can cause the issue