Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
we are in the progress of migrating our reporting from an OData datasource to a SQL server datasource as we've seen massive performance improvements when refreshing datasets stored on a SQL server.
Originally we were planning to use an Azure SQL Server but we're running into more and more problems and are now considering hosting the Server ourselves. This would of course mean that we also need a gateway to allow refreshes on the PBI service.
Is there any reason why one should not install the gateway on the same machine as the SQL Server other than security/privacy concerns? Can the gateway access a the SQL Server hosted on the same machine?
The obvious upside is of course that the gateway wouldn't have to go through the network to get data from the SQL server, thereby decreasing latency and ultimately increasing throughput.
Thanks!
Solved! Go to Solution.
Just a little followup:
We have this setup running for about a month now and its working perfectly.
My only concern is memory usage as the gateway does seem to like its RAM. I've limited the SQL server to 45GB memory on a 64gb server to leave some space for the gateway and OS to expand into.
We have the same setup (gateway on same machine as sql server) and it has been running fine for almost a year now.
Awesome, thanks a bunch!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.