Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago
Solved

Getting rid of source tables after append

If you append a whole lot of tables in 1, is there a way of getting rid of the original tables without losing the data - iit just seems redundant to keep the original tables.   When I try to delete...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi vanessafvg

     

    What you could do to increase performance is to disable the loading of your source tables in the Query Editor.

     

    This will not only make the data load a bit quicker, but it will also mean that it will not load into your data model. Which means that your data model will be smaller and more efficient.

     

    You can read this blog post by Rezza Rad where he goes into detail.

     

    Performance Tip for Power BI; Enable Load Sucks Memory Up

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

hi yes, thanks i do know about hiding it, i just really didn't want it to load 2x, i was wondering how to reduce the load.  I have a client file to evaluate and they have a variety of queries but are duplicating some of them, referencing the table would probably be a better option?  

 

thanks for the response. and here is the response i got on the global group which had some good tips too.  unfortuantely i have no idea how to get the link off facebook!  yes im clueless help, but here the group site page is

 

 

https://www.facebook.com/groups/powerbi/

 

 

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi vanessafvg

 

What you could do to increase performance is to disable the loading of your source tables in the Query Editor.

 

This will not only make the data load a bit quicker, but it will also mean that it will not load into your data model. Which means that your data model will be smaller and more efficient.

 

You can read this blog post by Rezza Rad where he goes into detail.

 

Performance Tip for Power BI; Enable Load Sucks Memory Up

  • tvandorffy's avatar
    tvandorffy
    Frequent Visitor
    8 years ago

    Hi @vanessafvg,

     

    I would like to ask a followup question.

     

    If I have several queries in my Power Bi Power Query and then I just append all of them into a new "Super Query"

    and I switch off "Enable load" to all my component tables (I would not need them in my model anyway),

    would their contents still refresh if I hit the "Refresh" button on my report page?

    I am asking this because if I switch off "Enable load" on a query, the "Include in report refresh" option becomes

    disabled, so I am not sure.

    What I would want is that if I hit report refresh, my several component table would refresh, and consequently,

    my "Super Query" would also refresh since its components are refreshed.

     

    Thanks a lot,

     

    Tamas

     

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      Yes that is exactly how it works
      • tvandorffy's avatar
        tvandorffy
        Frequent Visitor
        8 years ago

        Hi GilbertQ,

         

        Thanks for confirming. :-)

         

        Tamas