Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
The PBI Service Dataset settings shows me the two distinct servers:
I set up a schedule for refresh, but it always fails:
The Refresh history messages shows a seemingly random table each time as being the one to trip it up.
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.
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
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
Have you had any luck with this, i am experiencing this issue
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.