Forum Discussion
Performance issues while using one dataflow as source for many Datasets
We have a dataflow that's a bit large, with around 55 million records and we use it as a data source for four datasets. All datasets use Import mode to get the data from this dataflow. Three of t...
Your P1 capacity has a very limited set of renderers - six concurrent and 2400 per hour. What I would do is investigate if your dataset refresh is calling the dataflow twice, similar to what is described in this blog https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/ .
Have you tried to use the dataflow source in direct query mode?