New Dataverse connection times out - but old Common Data Service one did not - how do you load data?

[Anonymous]

Hi,

Connecting into Dynamics 365 CRM the new DataVerse connection times out with the error

"quotedetail

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: The request channel timed out while waiting for a reply after 00:02:00. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. RequestId: TDS;xxxx-xxxx-xxxx-xxxxxxxxx;2 Time: 2021-04-21T14:23:42.8187774Z. '."

Yet the "Common Data Service (legacy)" one does not.

[amitchandak]

@Anonymous , check do you see the timeout option, selected in the last update of this topic

https://community.powerbi.com/t5/Power-Query/Timeout-issue-on-dataverse-side/m-p/1628943

[Anonymous]

It is not SQLServer connection - which is last update on that topic.  So no that does not work

[v-lionel-msft]

Hi,

Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Docs

Did you do this last step?

Best regards,
Lionel Chen

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

[jsttheman]

Hello, I am getting the same timeout issue on the dataverse (direct query) connection but the prerequisites have been met. Do you know of any other solution?