Incremental Refresh Workaround

[thebadger77]

With incremental refresh not available in Pro, we're working on a workaround to reduce impact on server of refreshing 2 years worth of data each day

Approach is we have a fixed data source for last 23 months that does not refresh as part of load

Then another table which contains current month

(Each month we have to manually refresh the fixed data source)

I can create a new table with a DAX table expression to bring these together, but to replace the existing table it will be far easier to use PowerQuery M 

However, when I use PowerQuery to reference the other tables it refreshes them again, which defeats the point

Is there a way to amend a table, which is currently using SQL data, to become a DAX table? 

Thanks

[v-danhe-msft · Accepted solution]

Hi @thebadger77 ,

You may refer to below blog thay may help you to solve your problem:

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

Regards,

Daniel He

[thebadger77]

Thanks Daniel, unsure whether this works on the service though

[v-danhe-msft]

Hi @thebadger77 ,

OK, it it could help you, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He