Forum Discussion

yanmyoaung's avatar
yanmyoaung
Regular Visitor
2 years ago

Power BI Dataflow refreshment is giving more than one process for the same query

Why more than one process run at MS SQL server when I refresh my dataflow?

I saw that 4 or 5 processes run for the same query that I used in data.

My source table have 200 million records and refreshment is trying to load that much data 4 or 5 times when I refresh the dataflow.

Is it normal?

dataflow
Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please provide more details on the structure of your dataflow.  Check the lineage of your sources.  Use Table.Buffer.