Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |