cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User IV
Super User IV

Re: Portal won't allow me to setup scheduled refresh

Hi @rpm19841

 

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

 

EG

SQLServerVM 201.25.54.213

 

Then log into your Azure VM and put the following in your HOSTS File

EG

SQLServerVM 127.0.0.1

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

rpm19841
Frequent Visitor

Re: Portal won't allow me to setup scheduled refresh

@GilbertQ

 

You put me on the right path. 🙂

 

I just added this to the hosts file:

 

127.0.0.1 ServerName

 

So now on the machine, when accessed via "ServerName" it resolves to the local IP.

 

All good now.

 

Thanks so much for your help!!

Highlighted
Super User IV
Super User IV

Re: Portal won't allow me to setup scheduled refresh

Hi @rpm19841


Glad to assist and get it working, the Gateway setup can be quite tricky at times.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.