Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Hello @Sipaikanth ,
Did you finally have a solution for this issue? I have the same problem. Can you please share the solution?
SQL Server Analysis Service and some files from Shared drive
Are you attempting to merge them in Power Query?
AnalysisServices: The connection either timed out or was lost.
What's your actual data source?