Forum Discussion
Help Needed for Server Connection via Windows Authentication on Virtual Machine Using Power BI Gatew
in the gateway service web page create the connection, and specify Windows authentication.
Think of the Power BI gateway as a headless Power BI Desktop (same functionality, no user interface)
I’ve tried making the connection through the Power BI Gateway, but I'm not sure if the configuration is correct or if I need to do something else to work with the data from Power BI Desktop in my local environment.
These things are unrelated. You either work on the Desktop, or you work through the gateway. Not both at the same time.
You mentioned a VM. How are you logging in to that VM? Where is it located? Is it part of your Windows domain?
Thank you for your response and for the clarification regarding the relationship between Power BI Desktop and the Power BI Gateway.
As for the virtual machine (VM), I connect as follows:
- I install and configure the VPN client using FortiClient.
- I connect to the VPN.
- I access the Dynamics server from the VM.
- I use domain credentials to connect to SQL through Windows Authentication.
- Then, I validate the available databases.
Is the VM you log in to in a network location that has direct line of sight to the SQL Server database?
Are the On-Premise Gateway VMs in a network location that has direct line of sight to the SQL Server database?
It is correct, my VM has direct and uncomplicated access to the SQL Server through the network, and my 'On-Premise Gateway' is configured there on the server as shown in the previous images.