• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Power Query files now slow to inactive after switch to Windows 10|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Power Query files now slow to inactive after switch to Windows 10|Power Query|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumPower QueryPower Query files now slow to inact…
sp_PrintTopic sp_TopicIcon
Power Query files now slow to inactive after switch to Windows 10
Avatar
Mark Adams

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
September 12, 2020
sp_UserOfflineSmall Offline
1
September 12, 2020 - 1:52 am
sp_Permalink sp_Print

Hi, I work for a large company (40,000+) with a central IT department. We are just moving over to Windows 10 from Windows 7. I received a new Dell laptop this week with Intel i9 processor, 64Gb Ram etc, a powerful machine...and Windows 10. I use Windows 10 at home, since they brought it out and I like it...but the Power Queries that ran fine with O365 under Windows 7 and took maybe 5 minutes to run are now not completing at all after an hour under Windows 10. It's driving me nuts as I can't do my job at all. Can't even get on with any other work in Excel at the same time.

 

Any suggestions gratefully received. Have already checked Cortana is off which it was.

Regards

Mark

Avatar
Mark Adams

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
September 12, 2020
sp_UserOfflineSmall Offline
2
September 12, 2020 - 2:19 am
sp_Permalink sp_Print

I'm using Excel 64bit Version 2006 (Build 13001.20520 Click to Run) on a Monthly Enterprise Plan. I am getting data from 34 workbooks, appending those and then appending with an archive all in the same table format. I keep the majority of the queries as connection only and there's 145 queries in the workbook. Largest table size currently is about 30,000 rows and 33 columns. We don't use PowerBI as the company decided to go with Tableau, Tableau Prep, Google Big Query, and RapidMiner for analytics. They are great but the majority of my colleagues don't use or understand them so I still use Excel where I have to make files where others can also use them.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4447
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
3
September 12, 2020 - 8:19 am
sp_Permalink sp_Print sp_EditHistory

Hi Mark,

Having a look at your version I can see it's up to date. I'm not aware of any Power Query performance issues associated with a move from Win7 to Win10. I would get your IT people to reach out to Microsoft support through their SLA and have someone investigate ASAP.

I would also see if you can find a machine that is still on Win7 and test that the query still runs in 5 minutes, as I wonder if something in the back end has changed that is causing the problem.

Also check through the recommendations for speeding up Power Query refreshes here. Maybe you had those settings in Win7 but the move to Win10 changed them. Unlikely, but worth checking.

Mynda

Avatar
Mark Adams

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
September 12, 2020
sp_UserOfflineSmall Offline
4
September 12, 2020 - 6:11 pm
sp_Permalink sp_Print

Hi Mynda, thanks for the reply. I have raised a ticket with our IT department and I think they will re-install O365, probably on Monday now. I have done the Quick Fix and Online fix of O365 but it's still just as slow. I have managed to update all the queries now though so can produce the report that I needed to do. I have previously done the speedup fixes in your link but will check those again. 

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Jack Brett, Rocco Pinneri, Ivica Cvetkovski, LAFONSO HERNANDEZ
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Forum Stats:
Groups: 3
Forums: 24
Topics: 6211
Posts: 27239

 

Member Stats:
Guest Posters: 49
Members: 31891
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.