Forum Discussion
Power BI Refresh Issue (OLE DB or ODBC error: [DataSource.Error]... Timed out)
Hello,
I am experiencing an ongoing issue when trying to load data from our Fabric Data Warehouse into Power BI.
For quite some time, I have been unable to successfully load or refresh data from the Fabric warehouse. The process consistently fails with the following error:
> Failed to save modifications to the server. Error returned:
> 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.). An unexpected exception occurred.'
**Troubleshooting Steps Taken:**
* Verified that the data itself contains no errors or inconsistencies that could cause this issue.
* Tested using my user credentials on different machines (located in Greece/Athens) — the data loads quickly and successfully there.
* Confirmed that other users with identical permissions can access and refresh the data without issues.
* Worked with our Information Security team to verify that all required permissions and access configurations are correctly set.
* Attempted both:
* Full refresh (data + schema)
* Loading via “Transform Data”
→ The issue occurs in both scenarios.
* Created Environment Variable:
* Name: `PBI_SQL_TRUSTED_SERVERS`
* Value: [Fabric server address]
→ This did not resolve the issue.
Additional Notes:
* The issue appears to be environment-specific, as it only occurs on my machine/location.
* The error suggests a timeout during the SSL pre-login handshake phase, which may indicate a network, TLS, or local configuration issue.
Please check if your Fabric workspace is proctected with any firewall rules, if yes then you might need to connect your Org VPN in order to connect to fabric warehouse.
If not, if you would have connected to any VPN then try disconnecting from it and then open CMD and run the below command
ping <fabric warehosue hostname>if the above command gives a timeout then it is definetly a network connectivity error. If the above command works then try
telnet <fabric warehouse hostname> 1433even if the above command does not work, event then its a network error only. Work with your network team and get it fixed.
I have seen this multiple times. Most probably your VPN or network proxy settings are causing this issue. I suggest you to connect from your home internet or mobile network hotspot and not from Org internet. You will be able to identify the issue.
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
4 Replies
- Kagiyama_yutakaResponsive Resident
I think this one’s an env‑spc tls drop on ur local path, that’s why no one outside can really pin it… maybe flip off pbi’s File→Options→DataLoad→slow‑conn preview once, it lets the prelogin slip past any proxy/ssl‑inspect stalling it.
- tharunkumarRTKSuper User
Please check if your Fabric workspace is proctected with any firewall rules, if yes then you might need to connect your Org VPN in order to connect to fabric warehouse.
If not, if you would have connected to any VPN then try disconnecting from it and then open CMD and run the below command
ping <fabric warehosue hostname>if the above command gives a timeout then it is definetly a network connectivity error. If the above command works then try
telnet <fabric warehouse hostname> 1433even if the above command does not work, event then its a network error only. Work with your network team and get it fixed.
I have seen this multiple times. Most probably your VPN or network proxy settings are causing this issue. I suggest you to connect from your home internet or mobile network hotspot and not from Org internet. You will be able to identify the issue.
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
- v-nmadadi-msftCommunity Support
Hi YaelLearn
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you. - v-nmadadi-msftCommunity Support
Hi YaelLearn
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you