Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tctrout
Resolver III
Resolver III

Dataflow Editing / Preview Refresh Slow

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.

 

tctrout_0-1655296999586.png

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 statusCompleted
Duration00:43.7
Rows processed         687,376
Bytes processed (KB)         304,833
Max commit (KB)           97,600
Processor Time00:36.2
Wait time00:00.1
Compute engineFolded
ErrorNA



3 REPLIES 3
v-xiaoyan-msft
Community Support
Community Support

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.

@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?

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.