Refresh only unsynchronized data in power bi desktop without premium license.

[proavinash]

I have large dataset in which near about 6 years of data and it get increasing daily basis , so my problem sometimes i want to refesh only current date data or unsynchronized data till date.

please resolve this querry , thanks in advance.

[rohit1991 · Accepted solution]

Hi @proavinash 

You can’t really do true incremental refresh in Power BI Desktop unless you’re on Premium, because Desktop always reloads the full dataset.
What you can do instead is:

• Keep your old 6 years of data fixed (export once and load it back as a static table).
• For daily refresh, only pull new records from the source using a date filter (like TransactionDate >= Today()).
• Append the two tables together in Power Query, so only the small “new data” part refreshes.

Another option is to set up a parameter in Power Query for StartDate/EndDate and filter your source that way.

So basically, without Premium you’ll need to handle it manually by splitting old vs new data.