Close and Apply only one query

[lastnn30]

Hi

I wanted to Append 3 queries named (Jan, Feb, Mar). I managed to Append 3 queries and I called the new one as Total. Now if I go to Power Query --> Close and Apply, it will load to Power BI 4 queries (Jan, Feb, Mar and Total). Can I only load to Power BI only Total not Jan,Feb and Mar. Thank you very much.

[Arul · Accepted solution]

@lastnn30 ,

you can right click on Feb_Sales,Jan_Sales,Mar_Sales and uncheck Enable load option then it won't load all the data.Total would load to Power BI. FYI-if have visuals depends on those queries will break in the report.

Thanks,

Arul

[lastnn30]

Thank you so much for your help. I appreciate it.