Connection to SQL Server - trying to update individual columns instead of whole table

[jonjack]

Hi All,

Have a SQL Server connection to a large table (> 17M rows) and I have updates occuring daily to only 3 columns in that table. Is there a way to manually refresh the data for only those 3 columns instead of having to refresh the entire table?

Thanks in advance.

JJ

[amitchandak]

@jonjack , is the entire data updated? You can not run incremental?

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

[jonjack · Accepted solution]

Thanks @amitchandak - unfortunately, cannot use the date column for incremental refresh parameters because sometimes there are intake delays so a file that actually arrived at a prior date might be excluded. 

Separately, do you know of a solution that will alleviate the toll this file has on memory? Currently running 16GB of RAM and this file is taking up 90% (thus preventing me from making further edits to the dashboard). Is the only solution to install more RAM?