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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anon2005
Frequent Visitor

Append Queries as new but remove source

Hi,

I have a problem regarding Power Bi's "Append Query" system.

 

I have 4 independent queries that I want to combine as one but I don't want to keep the source queries.

If I try to delete them it just says that another query is linked to it.

 

Is there a workaround for this to save storage?

Thanks in advance!

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Anon2005 ,

 

If you right-click on the source queries of your appended table and uncheck 'Enable load' then these source tables won't be passed to the data model so there's no 'storage' implication. It's only the size of data that is included in the model itself, not anything in Power Query (apart from the text that makes up the M code for the queries, which is negligible), that takes up storage space, both on your HDD as the PBIX, and user memory (RAM), when using the report.

 

Depending how good you are with M code, you can nest your four source tables into a single query and append them within the same query, so you only have to look at one table in your Power Query list but, again, this will not save you any 'storage' space.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Anon2005 ,

 

If you right-click on the source queries of your appended table and uncheck 'Enable load' then these source tables won't be passed to the data model so there's no 'storage' implication. It's only the size of data that is included in the model itself, not anything in Power Query (apart from the text that makes up the M code for the queries, which is negligible), that takes up storage space, both on your HDD as the PBIX, and user memory (RAM), when using the report.

 

Depending how good you are with M code, you can nest your four source tables into a single query and append them within the same query, so you only have to look at one table in your Power Query list but, again, this will not save you any 'storage' space.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors