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, ...
HI nickyvv
Direct connection to the source data isn't possible at this time unfortunately. Would reducing the .dat files from monthly to weekly files change anything?
nickyvv
Most Valuable Professional
Most Valuable ProfessionalHi 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.
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.