Incremental Refresh for Delta Tables / Databricks

[moritzmassimo]

Hi guys,

I have quite big tables stored as Delta Tables in Azure Storage Account and also as Databricks Tables, that I need to connect to (Import mode!).

As those tables are quite big and the daily refresh must not take long, incremental refresh is definetely needed. Unfortunately it seems like query folding is not provided for delta tables or Databricks.

Do you have an idea how I can implement incremental refresh for those tables? Or maybe also an alternative idea for the storage of the tables is welcome.

Best,
Massimow

[v-yalanwu-msft]

Hi, @moritzmassimo ;

You can check if these related post can is useful to you.

https://www.reddit.com/r/PowerBI/comments/fuxevp/query_folding_with_incremental_refresh_and/

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.