Forum Discussion
OLE DB or ODBC error: [DataSource.Error] Unable to read data from the transport connection: An exist
Hi abhishekrws01 , Thank you for reaching out to the Microsoft Community Forum.
Since it works in Postman and used to work in Power BI, this points to a change in how the connection is being handled either on your end or the API’s. It's likely the API now enforces stricter security protocols like TLS 1.2. Power BI might be defaulting to an older version, which gets rejected.
To fix that, make sure your system is set to use TLS 1.2 by adding the SchUseStrongCrypto registry key, this tells Power BI’s underlying .NET framework to use stronger encryption. Also, make sure your API call in Power BI is structured correctly. A solid Web.Contents setup, with headers, timeout, and status handling avoids silent failures. Postman might be more forgiving, but APIs often expect specific headers and timeout behavior. Double-check your authentication. If you’re using an access token, make sure it hasn’t expired, Power BI might be holding onto a stale one. Re-authenticating from the data source settings can refresh this. It’s also worth checking if the API has changed, maybe they’ve added rate limits, tightened TLS rules, or started filtering by IP. Postman could still work if it uses a different IP or fresh token.
Lastly, if you’re using Power BI Service with a gateway, make sure it’s up to date and able to connect over HTTPS. Also try running the same query in a clean Power BI file, if that works, something in the original file might be cached or corrupted.
Also, Please refer to the below documentation:Install an on-premises data gateway
Overview of TLS termination and end to end TLS with Application Gateway
Transport Layer Security (TLS) best practices with .NET Framework
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
abhishekrws01 So are you using the Excel connector to connect to the Excel data or ?? Make absolutely certain that the Excel file is not open.
Hi -
No, I am fetching data through API. API works perfectly on Postman, and it worked in Power BI last month.
Thanks
Hi abhishekrws01 , Thank you for reaching out to the Microsoft Community Forum.
Since it works in Postman and used to work in Power BI, this points to a change in how the connection is being handled either on your end or the API’s. It's likely the API now enforces stricter security protocols like TLS 1.2. Power BI might be defaulting to an older version, which gets rejected.
To fix that, make sure your system is set to use TLS 1.2 by adding the SchUseStrongCrypto registry key, this tells Power BI’s underlying .NET framework to use stronger encryption. Also, make sure your API call in Power BI is structured correctly. A solid Web.Contents setup, with headers, timeout, and status handling avoids silent failures. Postman might be more forgiving, but APIs often expect specific headers and timeout behavior. Double-check your authentication. If you’re using an access token, make sure it hasn’t expired, Power BI might be holding onto a stale one. Re-authenticating from the data source settings can refresh this. It’s also worth checking if the API has changed, maybe they’ve added rate limits, tightened TLS rules, or started filtering by IP. Postman could still work if it uses a different IP or fresh token.
Lastly, if you’re using Power BI Service with a gateway, make sure it’s up to date and able to connect over HTTPS. Also try running the same query in a clean Power BI file, if that works, something in the original file might be cached or corrupted.
Also, Please refer to the below documentation:Install an on-premises data gateway
Overview of TLS termination and end to end TLS with Application Gateway
Transport Layer Security (TLS) best practices with .NET Framework
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.