Forum Discussion
Solved
To Power Query or Not to Power Query that is the Question
I have a table that has 140,000 rows with data and that is only 6 month's worth so it could potentially go up to 300,000 or more records by the end of the year. Originally I set up my workbook with ...
- Once again solved my own problem. I enabled Save source with data file in the pivot table that was connected to the PQ. It did increase the file to 12MB but that is still way lower than 42MB.
Once again solved my own problem. I enabled Save source with data file in the pivot table that was connected to the PQ. It did increase the file to 12MB but that is still way lower than 42MB.