cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

AutoML Data Flow refresh performance

Hi,

I've been using the AutoML feature in Data Flows and am having performance issues with the Data Flow refresh, I am using Azure A embedded tiers and have tried from A2 to A4 with the same performance issues. 

 

I have a simple dataset of 2 columns - Date and EventCount.  Number of rows is < 600.  A Regression model is selected and then it takes nearly 1 hour to do a refresh.  So it takes a long time to really do anything, as I then need to "Apply" model and it takes another 1 hour etc.

 

Has anyone else had performance issues?

 

Thanks

 

Andy

2 REPLIES 2
Rajatt
Microsoft
Microsoft

Hi Andy

 

The training report should mention the number of iterations that were run as part of this on the last tab of the report. Can you share that? We do have significant improvements coming within next two weeks to improve this but looking at the iteration count, it might explain a bit

 

Thanks

Rajat

Anonymous
Not applicable

Hi Rajat,

 

Yes, the details are: 

 

  • Input rows provided: 531
  • Sampled rows: 531
  • Training rows: 425
  • Final Model Used: Pre-fitted Soft Voting Regressor
  • Final model quality: 93%
  • Iterations run: 25

Pre-fitted Soft Voting Regressor final parameters:

  • max_models: 15
  • model_seed_threshold: 0.05
  • min_models: 1

Thanks

 

Andy

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors