Performance of PBI Dataflow (Gen 1) with Excel spreadsheet has significantly degraded

[QC]

Hi team, I noticed recently that Dataflow (Gen1) performance in connection with Excel spreadsheet has become significantly worse: I have a few dataflows connected with Excel on SharePoint, they used to take 2~3 minutes to refresh (very consistant), but in the past few weeks it has become +15 minutes, almost 4~5 times slower! 

What happened MS? I feel like the product overall is trending the wrong direction - it has become more and more bloated, but the most bread/butter services and performance/speed have become worse by each release ... 

[v-prasare · Accepted solution]

@QC, Hope your doing well.

we have received communication that the engineering team has fixed the Power BI Known issue : Fabric customers using Dataflows Gen1 and Gen2 may experience slowness while trying to ingest data f....

Can you confirm once if this is working fine for you or let me know if you still facing same issue?

Primary ICM:
https://portal.microsofticm.com/imp/v5/incidents/details/584394133/summary

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

[jochendecraene]

Same here, works fine

thnx

[QC]

Yes it is back to normal now, thank you for the prompt fix!

[v-prasare]

Hi @QC, Hope you are doing well.

Thanks for reaching out to MS FAbric community support

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

we recommend to submit your ideas here to Fabric team as these will be closely monitored by product team, they might address your issue propmptly: https://ideas.fabric.microsoft.com/ideas/search-ideas/

additionally, please refer to: Dataflows best practices - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS FAbric community support

[jochendecraene]

Same observation here. Loading data from sharepoint into dataflow Gen1 worked well. Has deteriorated drastically since last week and has become unworkable at times.

[QC]

I switched some of my sources to csv, which performance is still good, but I can't switch all, the performance of Excel right now is so bad. Honestly quite surprising b/c these are MS products, if MS couldn't even get the most basic thing right, it sends a loud message about overall QA/QC of the product