Computer Selection

[johnlhaase]

Hello

Does anyone have a good suggestion as to what computer configuration works best with Power Quey.

Desktop vs Laptop

CPU I7 vs I9

Ram 16 vs 32

I know what the minimum recomendations are but these are just minimums. I have an laptop with and I7, 16 Ram; I am wasting lots of time waiting for each step of my query to run. I see my CPU is reaching its limits but is this due to the number of Cores or Base Speed (2.21 GHz).

I need to justify a new purchase.

Thanks

John

[Greg_Deckler]

Desktop or Laptop, I9, 32 GB memory and SSD drives. 64-bit OS and Power BI installed.

[johnlhaase]

What does the 64-bit OS offer?

[v-eachen-msft]

Hi @johnlhaase ,

I think that Windows 10 ( newest version ) is more suitable for you.

[johnlhaase]

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

[edhans]

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.

[tantansu]

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.