Forum Discussion

lench's avatar
lench
Regular Visitor
1 year ago
Solved

Import table incrementally from ODBC on prem

Hi, i'm trying to import tables from on prem ODBC gateway. I use Dataflow gen2. I have a table with 32 million records. I've imported it once (took 4 hours). Now i would like to schedule an hourly ...
Dataflow
  • lbendlin's avatar
    lbendlin
    1 year ago

    The minimum granularity for incremental refresh is "day", as in "daily partitions".

    And since "Today"  means something different to the Power BI service than what it means to you (Remember the Power BI service runs on UTC)  it is very common that two partitions will be refreshed rather than one.

     

    Consider using advanced incremental refresh where the "Today" partition is kept in Direct Query mode.

     

    Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

lbendlin's avatar
lbendlin
Super User
1 year ago

The minimum granularity for incremental refresh is "day", as in "daily partitions".

And since "Today"  means something different to the Power BI service than what it means to you (Remember the Power BI service runs on UTC)  it is very common that two partitions will be refreshed rather than one.

 

Consider using advanced incremental refresh where the "Today" partition is kept in Direct Query mode.

 

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn