Forum Discussion
MAAbdullah_47
Helper V
Helper VPower bi DB server setup as alternative for Azure SQL server
Dear Experts I need to setup a power bi configuration for generating dashboard report on power bi services in environment similar to (azure sql server) , please review the attached Image with the th...
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.
MAAbdullah_47Helper V
Helper VHi 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?
lbendlin
Super User
Super User1. 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.
- MAAbdullah_47
Hi lbendlin for Q2 ?
- lbendlin
I have no experience on that part.