Forum Discussion
Power bi DB server setup as alternative for Azure SQL server
1. The recommendation is to keep the gateway VMs separate from the database servers, but as close as possible. That way you get best CPU and low latency.
You are missing the gateway component. Since your data is in a private cloud you need to have gateways that can broker between your data sources and the Power BI Azure Service. These gateway need to be able to see your private cloud data sources, so they will most likely also have to reside in that cloud.
Hi lbendlin you are right I explained this on (5) but not included on the diagram , what I'm asking here:
1-Shall I put the power bi Application for the refreshing purpose on the same host of the DB e.g.: MySql ? Or separated in another host?
2-For cost wise , Where can I find providers other than (MS Azure SQL server) who can satisfy the requirement on the diagram?
1. The recommendation is to keep the gateway VMs separate from the database servers, but as close as possible. That way you get best CPU and low latency.
Hi lbendlin for Q2 ?
I have no experience on that part.