Error connecting to Azure Synapse SQL Pool from PBI Desktop

[Daio]

Hi guys,

I have a few reports that connect to an Azure Synapse SQL Pool using DirectQuery. Everything works properly when I view the Reports from PBI Service, but when i download them and open them in PBI Desktop, i keep getting the "...target device actively refused connection". 

I would appreciate some help if you guys ran into this before.

Here are some details:

Feedback Type:
Frown (Error)

Timestamp:
2025-01-05T06:51:34.3313844Z

Local Time:
2025-01-05T08:51:34.3313844+02:00

Session ID:
999cff25-3d63-49bc-8950-b2aa152245e2

Release:
November 2024

Product Version:
2.138.1452.0 (24.11) (x64)

Stack Trace:
Microsoft.PowerBI.Client.Windows.MainWindow+AnalysisServicesCrashedAfterSuccessfulConnectionException
at Microsoft.PowerBI.Client.Windows.MainWindow.OnAnalysisServicesProcessExited(AnalysisServicesProcessExitedEventArgs e)
at Microsoft.Practices.Prism.PubSubEvents.EventSubscription`1.<>c__DisplayClass2.<GetExecutionStrategy>b__0(Object[] arguments)
at Microsoft.Practices.Prism.PubSubEvents.EventBase.InternalPublish(Object[] arguments)
at Microsoft.PowerBI.Client.Windows.Services.EventAggregationService.<>c__DisplayClass19_0`2.<PublishAndMarshalExceptions>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.138.1452.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.MainWindow","Error":"Microsoft.PowerBI.Client.Windows.MainWindow+AnalysisServicesCrashedAfterSuccessfulConnectionException","MethodDef":"OnAnalysisServicesProcessExited","ErrorOffset":"44","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.22631.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
71.6 GB

Private Memory:
1.11 GB

Peak Working Set:
1.45 GB

IE Version:
11.1.22621.0

User ID:
1a7e9cc3-c83c-457e-9783-2545bba0b9b2

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_mobileAutoReportLayout
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_odspSaveBackgroundUpload
PBI_publishDialogsSupportSubfolders
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_directLakeRemoteModeling
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Analysis Services Started Process ID:
18084

[v-xiaoyan-msft]

Hi @Daio ,

Could you please checke your firewall settings and see if it allow outbound traffic over port 1433, which is used by Azure SQL Database and Synapse SQL Pool,then verify that the Azure Synapse SQL Pool service is available and not paused or in the process of scaling?

Best regards.
Community Support Team_Caitlyn

[Daio]

Hi @v-xiaoyan-msft,

First of all, thank you for taking the time to look into this.

Port is open and Azure Synapse SQL Pool service is available and not scalling.

I forgot to mention that the issue doesn`t happen imediatly when opening the report. I can click around the report for a while, but after some time it throws the mentioned error and i couldn`t figure out what exactly is causing the error and if it is on the report side/the DirectQuery side/Power Query side.