Power BI Report is not Refreshing

[vinayrk]

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.

[v-easonf-msft]

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

[GilbertQ]

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]

Hi,

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

[GilbertQ]

Hi @vinayrk 

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