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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Sipaikanth
Regular Visitor

“Analysis Services: The connection either timed out or was lost.” at Power BI Service

Dear Team,

I am encountering an issue during the scheduled refresh of my Power BI model in the Power BI Service. Specifically, I am receiving the following error message:

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AnalysisServices: The connection either timed out or was lost."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AnalysisServices"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"10.14.0.40</ip>;Project Summary"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Project Summary.
Cluster URI:WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:8c5f940b-d722-478d-b64a-4781499aed52
Request ID:039d3938-1fc3-b5f9-ad5f-d07b2b8c4c0b
Time:2024-03-08 02:02:47Z

Interestingly, when I manually refresh the model, it sometimes succeeds, but at other times, it fails. Additionally, some datasets that share the same data sources are successful after the scheduled refresh takes place.

Could you please guide me on how to address this issue? Any assistance would be greatly appreciated.

Thank you for your attention.

4 REPLIES 4
Purva
Frequent Visitor

Hello @Sipaikanth ,

Did you finally have a solution for this issue? I have the same problem. Can you please share the solution?

Sipaikanth
Regular Visitor

SQL Server Analysis Service and some files from Shared drive

Are you attempting to merge them in Power Query?

lbendlin
Super User
Super User

AnalysisServices: The connection either timed out or was lost.

What's your actual data source?

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors