Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Thanks Daniel, unsure whether this works on the service though
Hi @thebadger77 ,
OK, it it could help you, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |