Forum Discussion

RahilBukhari's avatar
RahilBukhari
Icon for Advocate I rankAdvocate I
9 years ago

Power BI Refresh failure Azure SQL DB and On Premise SSAS

Hi I've got a simple Pbix which connects to Azure SQL DB and an On Premise SSAS Tabular (IaaS in Azure). We have an On Premise Gateway configured and this gateway works absolutely fine because we ha...
Gateways
RahilBukhari's avatar
RahilBukhari
Icon for Advocate I rankAdvocate I
9 years ago

Thanks v-haibl-msft

 

I tried adding the Azure SQL DB to the same gateway however it couldn't establish a connection and when i read up on it, you shouldn't have to create a gateway since it's already an Azure service, which has enabled access to other Azure services. I assumed this is why I had this error but the fact that you can create the connection suggests something else might be going on.

 

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

RahilBukhari

 

In Azure portal, have you enabled 'Allow access to Azure services' and set server firewall to provide access to client IPs?

Please refer to this document.

 

 

Best Regards,
Herbert