Forum Discussion
Reducing data size - remove columns or merge with 2nd table size
Hi,
I have data table A that seems to be too large for powerbi service to load (when I refresh it just loads and loads). It's over 10gb.
However I'm only interested in a sub set of Table A, and only some of the columns. In Desktop I have merged Table A with Table B (inner) to get only the rows I'm interested in, I have also removed columns I don't need. It seems to still be too large to load.
Performance wise, what should I be doing first, removing columns to reduce data width first, or merging Table A with Table B first to reduce the number of rows.
I use premium.
9 Replies
Hi Anonymous ,
Can you provide more details like below which might help to narrow down the bottleneck and resolve the issue -
Are you doing Incremental refresh and still you have this much data and performance is slow?
Any Network related issues during your refresh which might be causing the delay?
Best Regards,
- Pavan M.Anonymous
I'm not using incremental refresh.
It's a recently created report. I created it in desktop with a weeks worth of data, now I've published it to service for 3 months worth of data and the file isn't loading (the circle spinning icon just goes for an hour+). I'm trying to use the manual refresh icon in Service "dataset + dataflows" tab.
Table A is a several .dat files on sharepoint appended in M query.
I've used this advice to create Table A, then use it as an internal source before merging with Table B in a seperate query
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/