Forum Discussion
Incremental Refresh Workaround
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
Hi Anonymous ,
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
3 Replies
- v-danhe-msftMicrosoft Employee
Hi Anonymous ,
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
- AnonymousNot applicable
Thanks Daniel, unsure whether this works on the service though
- v-danhe-msftMicrosoft Employee
Hi Anonymous ,
OK, it it could help you, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He