Forum Discussion

kk2222's avatar
kk2222
Regular Visitor
6 years ago
Solved

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,

 

Need Help
  • kk2222's avatar
    kk2222
    6 years ago

    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

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    "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.

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    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 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi kk2222 ,

     

    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.

     

    • kk2222's avatar
      kk2222
      Regular Visitor
      6 years ago

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

  • kk2222's avatar
    kk2222
    Regular Visitor
    6 years ago

    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