Forum Discussion
Solved
Dataset refresh query
Hi there, When I have a scheduled refresh for a dataset that is connected to a SQL database (Set to 'Import data'), does this import the entire SQL table datasource connection for each refresh? ...
Hi jones_lilly
Yes, you are correct. Unless you have built any filters in with Power Query your refresh will pull the entire SQL table in on each refresh, replacing what was there. Thus if you add records to the SQL table that data will be imported with all the other data at the next refresh.
Hope this helps
Stuart
Hi jones_lilly
Yes, you are correct. Unless you have built any filters in with Power Query your refresh will pull the entire SQL table in on each refresh, replacing what was there. Thus if you add records to the SQL table that data will be imported with all the other data at the next refresh.
Hope this helps
Stuart