Forum Discussion

NaveenMohan's avatar
NaveenMohan
Frequent Visitor
2 years ago

Power BI Dataflow is taking more time to refresh.

Hello Everyone,   We have a Power BI Dataflow created using multiple views and each views created on top of one single view. When I execute the views at SQL, it is taking 18mints to get executed fo...
Dataflow
Need Help
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
2 years ago

Hi. I haven't heard about a way of running the tables in parallel at the same dataflow. You can split the dataflow and run them at the same time. If you want to reduce the time, the best approach would be changing views for Store procedures that creates tables. Then dataflows would query a table. That way there is no logic between the dataflow and the engine, it's just simple bring me data no logic.

I'll leave this article just in case you want to deep dive at dataflow practices: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh

I hope that helps,