Forum Discussion
Tips to optimize size for Excel files with Power Query codes
Hello, Just wondering if there are some tips / online resources on how to optimize the size of an Excel file that contains Power Query. In particular: 1. Is there any setting we can turn on / of...
HI freelensia ,
#1, I'm not so sure what setting/property you mean, can you please explain more detail?
#2, It is impossible to use excel connector to achieve this, maybe you can try to use odbc connection with query filters.
#3, You can take a look at following link about reduce excel file size methods:
8 Ways to Reduce Excel File Size (that actually work)
Regards,
Xiaoxin Sheng
Hi, thanks for your reply.
I am asking for tips to reduce the size of Excel files with power queries, not Excel files in general.
The examples I gave are just some imaginary settings I have in my head. I am not sure if they exist.
If you have any ways to reduce Excel files with power queries inside them, that would be very helpful.