Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
smather
Helper III
Helper III

OLE DB or ODBC error [DataSource.Error]

I'm using the Dataverse connector to connect to Dyanmics 365, and for a month everything was fine, until Monday when I got this error:

 

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

 

And now everytime I attempt to refresh it, it spits out that error. I've cleared global permissions, ran as admin, and zip, nadda, zilch. 

 

I'm connecting to Oppotunities within the Sales Hub and I have several different tables - won, lost, in progress, to ease the data load burden.

 

I'm at a lost on how to fix this and I'm still waiting for Microsoft to get back to me regarding this, so I thought I'd ask the community for any ideas?

4 REPLIES 4
amitchandak
Super User
Super User

@smather , Check issues if someone else also reported the same: https://community.powerbi.com/t5/Issues/idb-p/Issues

 

Log an issue or a support ticket

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

thanks @amitchandak I'll check that link. And I am waiting to hear back from Microsoft re: ticket regarding this issue, as mentioned, I just wanted to see if anyone else has had/have this issue an if they knew of a fix whilst I wait, given that they tend to take their time 🙂 

Anonymous
Not applicable

Hi @smather ,

 

Could please tell if there's any update from you opened ticket?

Hope your problem can be solved as soon as possible.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Anonymous  they're still bouncing me from person to person ☹️ hopefully I'll get a resolution soon. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.