Forum Discussion

vinayrk's avatar
vinayrk
Regular Visitor
5 years ago

Power BI Report is not Refreshing

Hi,

 

Need some urgent guidance .

 

I have built 3 power BI reports on an Azure VM with an data set from Azure SQL DB.   The PBIX file works fine from PBI Desktop and opens fine on other VM's & Desktops.   The connections opens up to the Azure SQL DB and data refreshes well.   The issue occurs when i publish this report to an workspace.  The data connections back to Azure SQL DB fails with the following error.

 

Refresh failed because this dataset requires a gateway. Please select a gateway from dataset settings.

Please try again later or contact support. If you contact support, please provide these details.

  • Activity ID1c0233b7-8d77-4049-bc05-b4e4d31cd959
  • Request ID82c8d54e-d67f-1e47-d311-393ca00efc32
  • Correlation ID348e4057-bf99-1081-1e54-dc9fffdd5fec
  • TimeMon Sep 14 2020 18:42:55 GMT+0000 (Greenwich Mean Time)
  • Service version13.0.14254.53
  • Client version2008.5.02820-train
  • Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net/

Any idea why there is the need for an gateway when everything is hosted on Azure.  What am i missing and how to fix this.

Dataflow
Need Help
Tips and Tricks

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago
    Hi there

    What is the connection you are using to connect to the Azure SQL DB?

    Is it the IP address or the FQDN?

    I would suggest changing it to use the FQDN which should then work without the gateway.

    The only other caveat is to make sure that your Azure SQL DB can be accessed from Azure/Power BI Services.
    • vinayrk's avatar
      vinayrk
      Regular Visitor
      5 years ago

      Hi,

       

      Yes, The connection uses the FQDN on the DB.  Also the SQL DB has the Azure Services selected to Allow.

      • GilbertQ's avatar
        GilbertQ
        Super User
        5 years ago

        Hi vinayrk 

         

        This is what I see for my source when it is connecting to Azure SQL DB

         

         

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, vinayrk 

    If you are  using Azure sql without any other on-premises data sources  in your dataset ,there is no need to install and configure the gateway.

    Please check whether there is any other on-premises datasource in your pbix file.

     

    Best Regards,
    Community Support Team _ Eason