Forum Discussion
Append Query only refresh one table
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.
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.
Thank you.
So I could turn the SQL Server off when I am not editing the report and users are accessing the report and turn it back on when I need to edit the report. Is that correct?
The Append query would still update with the data from TableB (data not from the SQL DB) so the users would see the latest data from the scheduled refresh plus the historical data?
