Power BI Dataflow Incremental refresh opening multiple connections in the Database

[sreedhary]

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.

[GilbertQ]

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