Ok my mistake in that it will not resolve to it's own Public IP Address.
Another option which might work is to edit your Hosts File. In here you can give it a simple name which will override and resolve to the IP Address via the name.
So where you have your Power BI Desktop you could put the following in your HOSTS File
SQLServerVM PUBLIC IP Address
Then log into your Azure VM and put the following in your HOSTS File
Then use the Servername of SQLServerVM in your Power BI Desktop and see if that works from the Desktop
And then once again edit or create a new Gateway Data Source in the Power BI Desktop and see if you can connect sucessfully?
Proud to be a Super User!
View solution in original post
You put me on the right path. 🙂
I just added this to the hosts file:
So now on the machine, when accessed via "ServerName" it resolves to the local IP.
All good now.
Thanks so much for your help!!
Glad to assist and get it working, the Gateway setup can be quite tricky at times.
Do you need help in Spanish? Check out our new Spanish community section.
Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.