Which Azure VM series would be good with intensive power query?

[bbbm]

We have some Azure VMs with data gateways (it works). 

But I noticed in testing refreshes, they're often hitting 100% CPU.  I'm sure this is because the data models in question have a ton of merges/unions going on, which imo Power Query isn't particularly good at (better to push that back to the Db - but it is what it is right now). 

There's very little guidance other than '8 cores', but are there any Azure VM CPUs that would be particularly well suited to intensive power query?  

[amitchandak]

@bbbm , How Much RAM do you have?

I am using 16GB RAM , processer equivalent of Xeon(R) CPU E7-4850 v4 @ 2.10GHz

Also increase memory management cache to 8-10 GB - in options and setting -> Option -> data load and check

[bbbm]

Also just found out these are running on Standard E2as v4

Maybe a Standard_B4ms would be better?  4 vcores instead of 2, but no more expensive

[bbbm]

16GB as well.

Will try that setting when testing tomorrow, thanks!