cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
L33 Frequent Visitor
Frequent Visitor

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 created a report in PBI Desktop that connects to our separate DEV and PROD Azure Servers with no issues - Desktop lets me blend the data without a complaint.

 

Like so:

Example of charting.PNG 

The PBI Service Dataset settings shows me the two distinct servers:Obfuscated Data source credentials.PNG

 

I set up a schedule for refresh, but it always fails:

RefreshErrorMessage.PNG

 

The Refresh history messages shows a seemingly random table each time as being the one to trip it up.

 

Refresh History eg1.PNG  Refresh History eg2.PNG 

 

If Power BI Desktop is letting me blend these sources in to the same report, what is it about the Service that is preventing it?

 

Is it a bug in the Service, or intentional for some reason? Is there a suggested workaround?

 

 

Thanks in advance.

 

3 REPLIES 3
Community Support Team
Community Support Team

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

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 Frequent Visitor
Frequent Visitor

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

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 New Member
New Member

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

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 52 members 861 guests
Please welcome our newest community members: