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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BileMG
Frequent Visitor

Dataflows in Premium are very slow

Hello,

 

after upgrading our Licensing from PowerBI Pro to PowerBI Premium, I am very disappointed 😞.
We are struggling since one week to use Dataflows in an effective Way, but every Day we face a new Problems. One of our biggest Problem is, that the refresh Performance is very, very slow.

When we use our Query in Power BI Desktop, it only takes 2-3 Minutes

When we use our Query in PowerBI Service to create a Dataset it takes also 2-3 Minutes,

But when we use the same Query in Dataflows, it take 40-50 Minutes.

 

The amount of Data for our Tests are not realy huge. It is a simple Table with Ø 2.1 Mio Lines and the output PBIX is 220 MB.

We tested everything that we have found in Community to solve the Problem.

 

  1. Reinstalling On-Premise Gateway
  2. Increasing Dataflow Capacity up to 60% of Ram
  3. Increasing Container Capacity to 15.000
  4. Cancelling all other Refresh, so that only the Dataflow has the whole Capacity of Server and Services

 

But nothings works. It is too slow to use it an effective Way.

So has anyone an Idea what we could also optimize, to have in Dataflows the same speed as in the other methods ?

 

 

Thx

 

Michael

3 REPLIES 3
Kenjoswe
Regular Visitor

Yes, Dataflows in PowerBI are very slow. All our data is in Azure. Refresh continue until timeout.

yoav_lubo
Helper I
Helper I

Dear Michael @BileMG 
were you able to find a solution for this issue?

Tnx in advance,

Yoav

v-shex-msft
Community Support
Community Support

Hi @BileMG,

In fact, refresh performance not only effect by power bi service status and resource, it also affected by other scenarios.

Where are your gateway hosted? Does your device contain enough idle resources for refresh operation? What about its network status? (these options all effect refresh performances)
In addition, have you changed your data region of the tenant when you upgrade licenses? (If your tenant region is different as your data source hosts, it may cause the issue)

BTW, you can also try to setting incremental refresh on your dataset to loading a small number of records to confirm if this issue is related to data amount.

Incremental refresh in Power BI Premium 

You can also contact to power premium support to trace the request to confirm the root reason for refresh performance. (power bi support ticket is free for pro and above licenses)

submit a support ticketsubmit a support ticket

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors