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

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

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        8 years ago
        Happy to assist
    • gk2go's avatar
      gk2go
      Icon for Helper III rankHelper III
      7 years ago

      GilbertQ, is it possible not to refresh the combined tables, after their first import?

       

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        7 years ago

        Hi there

         

        Unfortunately for now you have to refresh all the tables

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi GilbertQ , so to be extremely clear here. if I disable the load of my source tables, and keep only the appended table enabled, my appended table will be refreshed with new data if I update the data in my raw data files?