Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to avoid data refreshing when applying query changes?

Hi,   I have a Power BI report that purposely is not refreshed anymore due to the need to reflect the data as how it was stored at a certain point in time a while ago. Now there is a need to make a...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi Anonymous ,

     

    Quick-and-dirty fix:

     

    View your static table(s) in the Data view, right click on the table, select 'Copy table', paste to Excel/Access/Other in order to save as static position. Reconnect Power Query to this static source.

     

    Pete

asaetrang's avatar
asaetrang
Frequent Visitor
2 years ago

Hi,

 

I struggle with a similar issue.

When I add a new table in Power Query through a dataflow and apply the changes, it does not only load the new table but also loads my existing fact table even though I haven't done any changes to it. The loading time is therefore increased significantly since the fact table contains almost 2 million rows. Is there a way I can prevent this from happening?

I have tried to disable "Include in report refresh" without any luck, and disabling "Enable load" is not an option since this table is basically the base of the report.