Forum Discussion
Computer Selection
What does the 64-bit OS offer?
Thanks for the input.
If anyone else can confirm, Greg Dekler's post that would be helpful. The more responses I get on this subject the better.
I9 and 64GB SSD and Windows 10-64 bit
Thanks for the Posts
John Haase
You definitely want 64 bit. But, understand that Power Query can still run very very poorly on a million dollar super computer. If you have a bunch of nested tables referencing columns and doing effectively sub-queries, it will bomb.
And if you have an 8GB computer with a 128GB hard drive running an I5, Power Query can flat scream if your data source is SQL Server or a relational database and your queries are folding most or all of the work.
So as much depends on the code being efficient as it does on having a good machine, but the one Greg recommended is always a good start. I'd say processor performance will have more of a good impact on the DAX model than Power Query. To see how to make Power Query run well (or poorly) read ImkeF 's performance tips on Power Query. That is worth way more than a few GHz of processor and a few gigs of RAM.
he asked for with same power query file which is faster and how much. If you don't know, you don't have to answer. Everyone already knows what you're talking about. The question here is which of the processors gives better performance.
