OLE DB or ODBC error [DataSource.Error]

[smather]

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?

[amitchandak]

@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

[smather]

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 🙂 

[v-stephen-msft]

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.

[smather]

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