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 ,
I developed Report/Dashboard which will take data from a MS SQL Sever (with in network) . As per my knowledge Gateway needs to be installed & source config done only in that Host machine (say X ) where SQL Server is there .
Now question is can we install Gateway not physically in the X but some other machine (Y) which is acting a gateway to that SQL Server machine ..basically another m/c which might be connected to that SQL Sever ? I feel no.. can you please confirm ?
in case any solution like in same node/cluster..something..
Solved! Go to Solution.
As long as the machine you are installing the gateway on can see the database, say through SQL Serv Management Studio, it will work..
If you are refering to the on-prem Power BI gateway - it is recommended to have it installed on a separate machine. If that machine goes down you will have no access via powerbi desktop to your data.
It is fairly easy to congiure and the new updates to it, it can now be clustered.
I hope that helps!
As long as the machine you are installing the gateway on can see the database, say through SQL Serv Management Studio, it will work..
Hello , Thanks for your reply !
Are you then saying below flow would work ? Installation of Gateway and DB Source configuration will be as it is normal ?
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.