Keeping a copy of the original datasets in PowerQuery

[Anonymous]

Hi everyone,
I have a question regarding memory, refresh speed and perfomance of PowerQuery.

I would like to keep in PowerQuery a folder with the "Base Queries" that I use for my report (without importing them into the model). The reason for this is that after importing I need to merge, append, filter and do other stuff that would make my original queries difficult to find and analyze/compare to the final output if I need to. Therefore, I would like to keep a copy of the original queries with no work done over them at hand.

The question is: if I disable both load to model and include in refresh (I can refresh them manually when I need to use them), is there any other way in which they could impact the performance or the memory size of my report? Since this is not a must have feature (I can always trace back the original queries in the query steps, this is just a faster and more usable way to do it) I want to do it only if I'm certain it will not impact (or will impact very little) on size, performance and refresh of my report

Thanks 

[mahoneypat · Accepted solution]

You shouldn't need to uncheck Include in Report Refresh.  Unchecking just Enable Load for the query will be enough to keep it out of your loaded data model (and file size).  Your approach with using base queries is a good one (reference not duplicate).  Also see this video by Chris Webb to understand impact of data source settings (allow background, enable parallel loading, etc.).

https://www.youtube.com/watch?v=3uKNNZqBIkg

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[PradipMCT]

Try the connection query. That can help. YOu can go to Load to option and select connection only. Not sure if this is what you're asking for.