Forum Discussion
Dataset + dataflow in report
I have a dataset with customers, contracts, delivery sites etc. Smal dataset and refresh takes appr. 2 minutes. I have one dataflow with hour values. This one is quite large (300 million rows) but I...
The purpose of a dataflow is to shield you (the report developer) from a slow data source. Ingesting the dataflow into your dataset should be fast. If it isn't then maybe you are doing transforms after attaching to the dataflow.
You can do incremental refresh on your dataset if you want. Also note that with enhanced and XMLA based dataset refresh you have more flexibility on when to refresh which partition.
Also note that you can use Power Automate to chain the refreshes - initiate dataset refresn when the dataflow refresh has completed etc.