Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I am trying out dataflows and building some POCs.
I have a dataflow where I have pasted the query from Desktop to create a query.
However, when refreshing the dataflow, it takes a lot more time than the dataset which is using the exact same query.
Note that dataset is not pointing to dataflow yet. Both are using the same query.
In fact, Dataflow refresh takes more than double the amount of time it takes for dataset refresh
So, I would like to know if there is something which is slowing down the dataflow refresh. Is it something to do with memory alloted for dataflow as compared to dataset?
Regards
thanks for your response.
Yes, dataflow is using the on-prem gateway (note that dataset refresh is also using the same gateway).
I will check with my admin if we are using the latest version of on-prem gateway.
By enough hardware, do you mean enough hardware on the data source side or the server handling my gateway?
My concern is that dataset refresh is using exactly same hardware and gateway, but is performing better than my dataflow refresh.
And the difference is substantial.
Regards
thanks for your reply.
Good to know that MS is working on the improvements for dataflows.
Regarding hardware, yes, it can handle multiple refreshes as there are cases when more than datasets are being refreshed at the same time.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.