Forum Discussion

L33's avatar
L33
Frequent Visitor
8 years ago

Dataset refresh fails when merging data from two separate Azure SQL Servers

Hi,   I'm having an issue with a Dataset failing to refresh and it would appear to be to do with the fact my model is blending data from two separate databases in two separate Azure servers. I've c...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi L33,

 

Please check if you have configured the two data sources correctly in "manage gateway". In addtion, in Azure portal, have you enabled 'Allow access to Azure services' and set server firewall to provide access to client IPs?

 

Regards,

Jimmy Tao

L33's avatar
L33
Frequent Visitor
7 years ago

Hi,

The "Gateway connection" section tells me I don't need a gateway - as I suspected. Both servers are in the Azure cloud. Additionally, when I have a PBI dataset from one or the other, it works fine. It's only bringing two separate servers' data together that seems to cause a problem. 

 

thanks

  • igorya76's avatar
    igorya76
    New Member
    7 years ago

    Have you had any luck with this, i am experiencing this issue