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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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?

Super User
Super User

@smather , Check issues if someone else also reported the same:


Log an issue or a support ticket

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 🙂 

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.

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

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.