Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Connection to Azure DB requesting Gateway for Power BI Service

  Apologies if there is a thred answering this already. I could not find one.   We have several reports that connect to an Azure SQL DB without a data gateway (from what I have read, this is perfe...
Need Help
RenuKshirsagar's avatar
RenuKshirsagar
Advocate II
5 years ago

Hello Anonymous ,  

 

The first error image implies that your Client IP address doesn't have access to the master database and thus you need to have a firewall rule set up in the Azure Management Portal for your Client IP address. 

 

You may ignore the Gateway connection section as it only lists down the server details for Azure DB. Its credentials will be mapped in the Data sources settings section. So you can try to set up the firewall rule and confirm the refresh status.  

 

If this was helpful, then kindly hit LIKE and promote this information as a solution to help other end users reach the correct answer.

 

Thanks,  

Renu KS

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Renu

     

    Thanks for your response

     

    What is the firewall rule for? I have many reports getting data from the same DB without the need for this.

     

    Thanks

    Sam

    • RenuKshirsagar's avatar
      RenuKshirsagar
      Advocate II
      5 years ago

      Hello Anonymous ,

       

      There are server-level firewall that blocks clients from connecting to the Azure SQL DB. Therefore we need to set up a firewall rule in Azure to enable your Client IP communicate with the server. You need to perform the following:

       

      1) Open Azure Portal

      2) Go to your Azure SQL DB section

      3) On the left pane you should find an option for Firewalls and Virtual Network

       

      Enter your information and try to refresh the dataset once again.  

       

      --------------

      Can you provide more details on the reports for which you were able to schedule the refreshes successfully? What is the difference between this one and the others? Is it that you are merging a file's data with this DB?

       

       

       

       

      If this reply was informative and helpful, I would appreciate a LIKE on the reply or promote this as a solution if it resolved your error.

       

      Thanks,  

      Renu KS