Dataflow Editing / Preview Refresh Slow

[tctrout]

Looking for guidance & explanation on possibly why a Dataflow built in a P1 Premium Capacity is very slow to edit and load the data previews.  The refresh is very performant, completing in under 2 minutes.  However when editing / previewing the data it takes 10+ minutes to see the preview data loaded.

I captured the metrics provided at the bottom of the dataflow build.  I can see the throughput is 8.4KB/sec which is painfully slow, but what does this represent?  Is this my local machine internet speed?  Also, I see CPU spikes as high as 100%, what does this represent?  Is there a white paper outlining the below metrics?

The dataflow refresh itself takes under 2 minutes and the capacity metrics app indicates no concerns.  Trying to figure out how this translates to the below metrics and why editing the dataflow is slow.

Update:
I now throw out of memory errors within the edit dataflow data preview but not in the dataflow refresh.  Below are the details of the 'troublesome' entity that cannot load in data preview within edit dataflows.  Not sure why as the below confirms an effecient dataflow leveraging Query Folding.  

I wanted to configure the dataflow settings within our premium capacity but now the Dataflow section is missing under Workload within the Capacity settings of the admin portal.  I created another thread on this specifically.

Can anyone help?

Refresh status	Completed
Duration	00:43.7
Rows processed	687,376
Bytes processed (KB)	304,833
Max commit (KB)	97,600
Processor Time	00:36.2
Wait time	00:00.1
Compute engine	Folded
Error	NA

[v-xiaoyan-msft]

Hi @tctrout ,

The following sections describe how to enable dataflows in your organization, how to refine their settings in your Premium capacity, and guidance for common usage.

Configure Power BI Premium dataflow workloads 

Hope it helps,

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[tctrout]

@v-xiaoyan-msft 

Thank you for the information.  Researching more and providing more context, I have Gen2 Premium Capacity.  The setting outlined in the provided link do not exist on Gen2 Capacities;  there is no Daflow workloads section under the admin portal.  I opened a separate ticket on this and was informed that this was be design, Gen2 Premium Capacities do not enable you to allocate a % of your capacity to workloads as the workloads are automatically done for you as part of the Gen2 Premium Capacity.

I am now starting to believe these issues are more to do with Gen 2 Premium Capacity and less to do with Dataflows.  I speculate that not all the kinks have been worked out for Dataflows on Gen2 Premium.  

Is there any documentation supporting this?

[JR-DCPS]

I remember seeing it in Gen2 before the datamart introduction, but you are right. It's not there anymore.