Hi,

I tend to prefer SQL Server machines to only host SQL Server as you want all your memory and CPU dedicated to your databases.

Whether mixing TDI/TX and the PBI Gateway on a single VM will work depends on how much load your gateway will generate. Microsoft's advice is a bit on the high side (I guess it is aimed at being the sole vector for PBI access to data without a DWH in between for “most” organisations), but the different types of load are useful to know about: https://learn.microsoft.com/en-us/power-bi/guidance/gateway-onprem-sizing

Thanks Rory. I agree with you on leaving SQL to do it’s thing.

It might be a case of trying it on the TDI server and seeing how it goes. We don’t know what volumes we’re dealing with yet so it is hard to estimate and size accordingly.

​@rory.smith before I close this thread off, do you know if you can use a single gateway server for multiple clients, i.e. in a managed service environment?

Hi,

I suspect that will hinge on the details. If you are connecting to data sources hosted in different domains that may be a bit complicated for instance.