Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
kk2222
Regular Visitor

Am I able to refresh without using gateway if SQL is Azure but hosted by a vendor

Hello,

 

Hope this is the right place to post and someone is able to answer,

 

I have published a report to my departments workgroup which has a single data source which I selected as Azure SQL with basic login credentials which accesses one of our vendors servers I am told is Azure.

 

When I try to refresh I am prompted with a gateway connection problem (image 1)

When I nagivate to schedule a refresh it is greyed out (image 2)

 

Thanks! let me know if I missed any format guidelines

 

Regards,

 

1.jpg2.jpg

1 ACCEPTED SOLUTION
kk2222
Regular Visitor

Thanks everyone, 

 

IT was able to provide me with priveleges to configure the enterprise gateway and I can not auto refresh.

 

It sounds like Azure doesn't necessarily mean ability to refresh without gateway, the database is housed by one of our vendors and not within our intranet.

 

I am able to auto refresh successfully without gateway to another azure server which is hosted by us. 

 

Thanks everyone for the help and suggestions 🙂

 

Keith

View solution in original post

5 REPLIES 5
kk2222
Regular Visitor

Thanks everyone, 

 

IT was able to provide me with priveleges to configure the enterprise gateway and I can not auto refresh.

 

It sounds like Azure doesn't necessarily mean ability to refresh without gateway, the database is housed by one of our vendors and not within our intranet.

 

I am able to auto refresh successfully without gateway to another azure server which is hosted by us. 

 

Thanks everyone for the help and suggestions 🙂

 

Keith

v-lionel-msft
Community Support
Community Support

Hi @kk2222 ,

 

v-lionel-msft_0-1595224472038.png

Didn't these two suggestions help you?

Please show the gateway configuration.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hey Lionel, thx for responding but no lol... my subject line indicated I was looking to connect without the gateway.

venal
Memorable Member
Memorable Member

@kk2222 

Can you able to ping the vendor's machine(Azure SQL) from the On-premises data gateway machine.

If not, please check with your internal it team for the help.

If yes, Please raise a support ticket to investigate the issue by clicking on "show technical details".

https://powerbi.microsoft.com/en-us/support/

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @

 

BR

@venal 

lbendlin
Super User
Super User

"Azure"  and "Azure" are two different things. What they mean is that the database has to be directly available on the interwebs, with no firewall between it and the Azure Service Bus.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors