Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Refresh Staggering Performances...

Hi guys, I have a connection to a sql table in my power bi desktop. When i refresh in the desktop version (about 4000 rows) -> it takes less than 20-30 seconds When i publish it on app.powerbi and...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    HI Anonymous 

     

     1. The data for these rows loads into memory and is uncompressed at every refresh. This processing creates huge demands for memory. The solution: use the "Top N" filter to reduce the max number of items that the table displays. You can set the max item to larger than what users would need, for example, 2000. The result is the end-user experience doesn't change, but memory use drops greatly. And most importantly, performance improves.

    2. You should probably optimize your capacity, see Optimizing Premium capacities.

    3. To understand gateway workloads and sizing recommendations, see On-premises data gateway sizing.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

for 1), you mean in the matrix tables that I have in my dashboard, i should filter them to show only a subset of the data?