Forum Discussion

RahilBukhari's avatar
RahilBukhari
Advocate 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
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

RahilBukhari

 

You need to add these two data sources to the same gateway, one for Azure SQL and one for on-premises AS as below.

 

 

 

Best Regards,
Herbert

RahilBukhari's avatar
RahilBukhari
Advocate 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
    Microsoft 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