Forum Discussion
Incremental Refresh on a dataset with Dataflows as a data source
Hi Anonymous,
Thanks for backing me up :).
I tried to ask this simple question multiple times in this thread but it doesn't seem to land properly. I just want to know if it's on the roadmap at least. Anyways, it became a lower priority for me since the rollout of Direct Query on Dataflows. Haven't gotten the chance yet to test it properly, but at least in theory it offers a solution to the unnecessary refresh time of the datasets that are running on Dataflows.
Hi Anonymous ,
Thanks for your answer and hint regarding "DirectQuery on Dataflows".
I am not sure if this is really an "equivalent" solution because like this we cannot use the (speed & performance) advantage of importet Datasets (i.e. in-memory/columnar engine) so I wonder if you have already results and user feedback for interactive queries/filters on "DirectQuery-based" reports ? Are they still performant (latency ?) at all and especially with a larger number of users sending direct queries every time to the underlying Dataflow ?
AnonymousCould you please check again on the "simple question" if the setup "Incremental Data Refresh of Datasets on incrementally refreshed Dataflows" works and is officially supported by Microsoft, thank you.
Best regards
Anonymous Not yet. I also don't think it will be an equally performing solution. While it feels like it should be the type of solution that helps us leverage Dataflows to scale throughout large organisations.
Anyways, it doesn't seem like we are getting a satisfying answer from Microsoft regarding our problem.
I'll let you know when we've tested the DirectQuery solution.