Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
cceashe
New Member

Scheduled refresh fails with 'Cannot Connect to the Mashup data Source'

Hello,

we have on the premise data gateway installed and have a scheduled data source refresh daily. This has been running for around two months but has recently started failing with the error on the subject line.

 

The Detail shows this:

 

Underlying error code: -2146467259

Underlying error message: Microsoft SQL: Query timeout expired

Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net

 

I've executed the query in sql server managment studio and it is slow  but does complete so I'm not sure if the timeout is occurring at our end or yours?

 

Can you suggest next steps in investigate further?

 

Regards

 

 

2 REPLIES 2

@cceashe Make sure you are on the latest gateway. There was a post on the support site related to publishing PBIX files in Northern Europe, but I haven't seen anything specific to refresh failure.

Another option is to performance tune the query since you mention SQL.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

The default command timeout is 10 minutes. If your query runs more than that and there is no way of optimizin it, maybe its worth considering. Have a look at https://msdn.microsoft.com/en-us/library/mt260902.aspx CommandTimeout option in particular.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors