Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
4 years ago
Solved

Close and Apply only one query

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.

 

Need Help
  • Arul's avatar
    Arul
    4 years ago

    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

2 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      lastnn30
      Icon for Post Patron rankPost Patron
      4 years ago

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