Forum Discussion
PowerQuery: Delete unnecessary queries
Hi,
I have several queries happening in PowerQuery.
Query 1 = pulling all data from source 1
Query 2 = pulling all data from source 2
Query 3 = Merge query 1 and 2 with inner join = all rows from query 1 and 2 that are matching
Query 4 = left anti join merge query 2 and 3 = all rows from 2 and 3 that are not matching
Query 5 = Merge Query 1 and query 4. This is my final result.
Query 5 is the only query that I then use in PowerBi to run my analysis, all other queries are hidden in PowerBI.
Queries 1 through 4 do take up quite some disk space and makes my file a bit slower. Is there any possibilty to delete a query after you used it? Or is there an option to not send its results to PowerBi?
Regards
Bas
Hi Anonymous
If you right-click on the query and deselect the "Enable load" option the query will not be loaded into Power BI.
As to deleting them, you could but from what I understand your Query 5 depends on all the previous ones. If that's the case you cannot delete them.
2 Replies
Hi Anonymous
If you right-click on the query and deselect the "Enable load" option the query will not be loaded into Power BI.
As to deleting them, you could but from what I understand your Query 5 depends on all the previous ones. If that's the case you cannot delete them.