Forum Discussion
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 refresh it or even re-query the source (it contains over 1 million rows).
TableB comes from a different database that gets updated a lot and I would like to refresh it once a day.
TableA and TableB are appended in to a new table called Append1
I have tried setting TableA to not refresh but the Append1 still queries the SQL database.
Is it possible to set refresh for only one of the tables in Append1?
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.
8 Replies
Did you set the connection to TableA as Import or Direct Query?
Pretty sure I used Import, is there a way to double check?
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.
