Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Persisting List

Hi All,   I'd like to do some incremental refresh, and i've been thinking about this: 2 tables, the one with the initial set and the second one with the increment. I convert both of them to List,...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

We cannot setup the incremental refresh using PowerQuery directly, List.Combine requires multiple dataset, but in your scenario, we can't use the Datas as the sataset. When we click the Refresh Preview button, the full dataset will be refreshed.

Actually, PowerBI Service provides the incremental refresh feature for Premium user, please refer to this blog: https://powerbi.microsoft.com/en-us/blog/incremental-refresh-in-power-bi-premium/

Best Regards,

Teige

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi TeigeGao,

     

    Thank you for your reply.
    I can't currently use the Premium feature and to be more specific about my case, the initial data (called Datas in my code) is not included in the report refresh, to avoid precisely that its content is cleaned up during an update.
     
    I've been thinking to another thing:
    - Doing my refresh to get my increment
    - In Datas, I'm using func.InvokeAfter(f, #duration(....)) to delay the execution of the combine after the load of the increment but it gives me a circular reference error because it execute again the script when you use it's name.... :(
     
    I've seen something in Excel doing this but it's seems that it doesn't work in Power BI Desktop....
     
    So if anyone have an idea ;)
    Thanks,
    Christopher