Forum Discussion
Anonymous
6 years agoNot applicable
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, ...
nickyvv
Most Valuable Professional
6 years agoHi Anonymous,
that would certainly help. You'll have to join them back together in Power BI, but that could solve the problem of timeouts.
that would certainly help. You'll have to join them back together in Power BI, but that could solve the problem of timeouts.
Anonymous
6 years agoNot applicable
I currently join them together in M query using the import sharepoint folder option so it's appending all files into one big one before doing data transformations on them. I'll try splitting the data down and report back.