cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ARamirez1970
Frequent Visitor

PowerQuery editor at each step reloading source CSV file (becoming SLOWWWW...)

I'm using the PQ editor from Excel, loading a relatively small CSV file (3.6 MB), with a moderate number of rows (18,000), which, in the PQ editor, I then group into a much smaller table with under 100 rows and 7 columns.

 

However, each time I add an even simple step such as changing the data type from Whole number to Text, PQ seems to reload the source data all over again: I can see the lower right corner showing a progress message like "xxx MB from [file name.CSV]" with the xxx number going up, until ending with a mesage saying "PREVIEW DOWNLOADED AT 10:35 AM".  Why is PQ doing this?  I've tried fiddling with the Query Options with no luck.

  

I've already tried "Column profiling based on to 1000 rows", BTW. Does nothing, still reloads the file with each new step.

2 ACCEPTED SOLUTIONS
mahoneypat
Microsoft
Microsoft

In File/Options and Settings/Options, under Data Load (Global and/or Local File) uncheck the "Allow background refresh ..." option.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

This did it! Thanks so much

View solution in original post

4 REPLIES 4
KT_Bsmart2gethe
Super User
Super User

Hi  @ARamirez1970 ,

 

Where did you saved the source file?

 

Regards

KT

In a Google Drive shared folder

mahoneypat
Microsoft
Microsoft

In File/Options and Settings/Options, under Data Load (Global and/or Local File) uncheck the "Allow background refresh ..." option.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


This did it! Thanks so much

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors