Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Keeping a copy of the original datasets in PowerQuery

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 


1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Employee
Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


PradipMCT
Resolver II
Resolver II

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors