Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Refresh Semantic Model with Import Mode

Hello everyone! I’m having some difficulty understanding the following: Task: I want to migrate my model to Fabric with Import storage mode, while the connection is to an on-prem SQL database. I’...
Need Help
Tips and Tricks
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous 

     

    • Import Mode (No Incremental Refresh):

      • Refresh re-imports all data.
      • Slower for large models; may appear unchanged due to caching.

    • Import Mode (With Incremental Refresh):

      • Only recent partitions (e.g., last 2 months) are refreshed.
      • Faster subsequent refreshes, as older data remains untouched.

    Incremental refresh optimizes performance by targeting specific partitions, reducing refresh time for large datasets.

    Plain Import mode re-imports data entirely, leading to longer refresh times for large models.
    If this post helped please do give a kudos and accept this as a solution 
    Thanks In Advance

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

 

  • Import Mode (No Incremental Refresh):

    • Refresh re-imports all data.
    • Slower for large models; may appear unchanged due to caching.

  • Import Mode (With Incremental Refresh):

    • Only recent partitions (e.g., last 2 months) are refreshed.
    • Faster subsequent refreshes, as older data remains untouched.

Incremental refresh optimizes performance by targeting specific partitions, reducing refresh time for large datasets.

Plain Import mode re-imports data entirely, leading to longer refresh times for large models.
If this post helped please do give a kudos and accept this as a solution 
Thanks In Advance