Forum Discussion
Unable to access DB from Azure Virtual Machine using Gateway
Hi Ibarrau,
Currently has switch to standard gateway connection, it seems connected successfully. So i check setting for "dashboard name" > data source settings for certain data it displays:
However for manage gateway settings > data source settings, i have choose:Use SSO via Kerberos for DirectQuery And Import queries
with basic authentications only it connects.
If i didnt choose that option, the connection will failed.
Atlthough the connection display it was sucessfull, when i try to refresh dahsboard on power bi app on web, it doesnt refresh at all.
If gateway doesnt work, is there any other option than using gateway to access DB?
Thanks.
Hi. You don't have to skip connection. Otherwise we won't know if that's ok. I looks like there is somethign wrong in configuration you made because it can't get to it. If you force to test connection the gateway won't allow the data source unless it's really ready to do it.
Maybe a recap from this video can help you:
https://www.youtube.com/watch?v=Vlv1tbuZNcM
Regards,
Hi, Ibarrau.
I think configuration doesnt went wrong since i had tried several ways before that. Refer from error details below:I assume the problem is come from IP address, i had been tried to insert network port test IP address into virtual machine, but the error remains same.
Any more solutions for these?
It's clearly a problem of the VM with the SQL Server. You have to allow remote conections to the server and check if there is something else in the network blocking access. You might need to read about this in microsoft doc or check some youtube videos unless you have a database administrator to ask about it :S
Regards,
Hi ibarrau,
Currently connection issue is solved by insert certain region of Public IP from azure services under this website
https://www.microsoft.com/en-us/download/details.aspx?id=56519&ranMID=24542&ranEAID=je6NUbpObpQ&ranSiteID=je6NUbpObpQ-7gEFFkuxnhi32xtiQ.8Upw&epi=je6NUbpObpQ-7gEFFkuxnhi32xtiQ.8Upw&irgwc=1&OCID=AID2000142_aff_7593_1243925&tduid=%28ir__yv13hbbtrskfqhjikk0sohzz2u2xpuaq1jhps9rc00%29%287593%29%281243925%29%28je6NUbpObpQ-7gEFFkuxnhi32xtiQ.8Upw%29%28%29&irclickid=_yv13hbbtrskfqhjikk0sohzz2u2xpuaq1jhps9rc00
Other than that, is there a way to find certain IP address that my current Power BI server using under certain region?