Power BI dataflow refresh error

[allanrayg]

Hi!

I'm testing Datamart for our org and I'm currently getting an error when my dataflow is connecting to Datamart as a datasource. This particularly happens to a larger data, while other dataflows are working fine, but with occasional errors.

Data Source Error : DataSource.Error: Microsoft SQL: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider error: 0 - An existing connection was forcibly closed by the remote host.)

DataSourceKind = PowerBIDatamarts

ErrorCode = -2146232060

Number = 10054

Class = 20

I've been searching on the above errors but couldn't find related ones to Power BI dataflow and datamart. Any assistance would be appreciated, thanks!