Forum Discussion

sreedhary's avatar
sreedhary
Helper I
2 years ago

Power BI Dataflow Incremental refresh opening multiple connections in the Database

Hi,

 

We see the Power BI is opening multiple connections to the database when the dataflow with incremental refresh- (IR) enabled. Looks like it is opening one connection for each partition. Example, if we set to incrementally refresh (IR) for last 7 days, it's opening around 7 sessions/connections in the Oracle database. This is causing slowness in the overall refresh process as we have multiple dataflows with IR eanbled. Is this normal behavior? How to get around this?  

 

Please advise.

 

Thank you in advance.

Dataflow

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi sreedhary 

     

    Yes, this is normal because it tries to process the partitions in parallel. What you could potentially do is look to see if there is an option to process the partitions one at a time. It might be in the data flow settings