Forum Discussion
Solved
Append Query only refresh one table
I have two tables from different data sources. TableA comes from a SQL Database that contains a lot of historical data that will never be changed. Once the data is in PowerBI, I do not want to refre...
In Power Query in the first steps, by clicking on the gear icon. If it's import, just by deselecting the option "Include in report refresh" should do it. On Power Query it queries frequently the data as it gets data previews in order for you to apply steps, but once published, that Table will never get updated.
As to my knowledge, SQL Server needs to be turned on just for the connection to stay alive. Since you already indicated that you don't want that table to be refreshed, Power BI will not query against it once the refresh process comes up. If you won't ever need again to do anything with TableA then I would say that yes you can turn it off.
Thank you so much.