The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone,
I'm encountering an issue while trying to refresh a Power BI dataset connected to a SQL Server. The error message is as follows:
```
OLE DB or ODBC 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.). An unexpected exception occurred.
```
Additionally, using another data tables (with only 1000 rows for testing my connection) from the same connection the SQL Server log shows:
```
Msg 10054, Level 20, State 0, Line 0 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.)
Completion time: 2024-06-20T16:05:08.0488957+07:00
```
I am only trying to load 1000 rows, so the query complexity shouldn't be an issue (CMIIW). Has anyone experienced a similar issue or can provide any guidance on resolving this?
Thank you!
note : I am using "Import Connection" to the database
Additional information from @Idrissshatila
this is the query editor information:
the information on Mquery editor :
```
= xxx{[Schema="yyy",
Item="zzz"]} [Data]
```
The error message info:
```
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.)
Details:
DataSourceKind=SQL
DataSourcePath=xxx.net;xxx
Message=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.)
ErrorCode =- 2146232060
Number=10054
```
thanks
Hello @ZiyadSyauqi ,
go into power query on this table and check the error there, it will lead you to the error .
Proud to be a Super User! | |
it shows error as follows:
any idea?