Skip to main content

Power BI

Completed

DirectQuery to a Dataflow from a Dataset

Vote (2) Share
Steven Kramer's profile image

Steven Kramer on 15 May 2021 00:07:55

Right now a dataflow has to refresh then we have to wait a minimum of 30 minutes for the corresponding dataset dependent on that data to refresh. If the dataflow only takes 2 minutes to complete, it would be fantastic if the dataset could access the most up to date information immediately. Also, if a dataflow happened to take more that 30 minutes to refresh and completed after the corresponding dataset's scheduled refresh, then the data in a dataset could become very stale in an import design. If you could DirectQuery a dataflow, the issue with matching up schedules becomes irrelevant.

Administrator on 18 Apr 2022 20:46:31

The ability to use DirectQuery with a dataflow exists today, to learn more: https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features?tabs=gen2