Hi all,
As per the article below, it mentions that when hosting the prepare instance on-prem, you need to install the Power BI Gateway.
Power BI Premium Endpoint | Community
Does anyone have experience of this, and if so, have you installed it on a dedicated server or on the same server as the Ingest or SQL servers?
For this scenario, the data will be loaded once daily.
Thanks,
Richard
Best answer by rory.smith
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
+8Hi,
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.
+8Hi,
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
