Forum Discussion
Timeout from Dataverse
I have a series of tables in my dataset whose Source is Dataverse. I simply clicked the Dataverse button, supplied the environment URL and went about my day. However now, whenever I Refresh my dataset, I have one table that is taking longer than 5 minutes to grab all the data and I'm getting the following Timeout error:
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: The request channel timed out while waiting for a reply after 00:05: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;69f3a5bc-ff0e-460e-8289-4d8c8ced9015;2 Time: 2021-09-01T19:00:59.1452673Z.
The first Power Query Source step looks like the following:
= CommonDataService.Database("orgXXXXXXXX.crm.dynamics.com")
Please help me, as I'm trying to simply use a Microsoft product to pull in data from another Microsoft product and it's not working. Can I extend the timeout somewhere? Do I need to change my source step?
4 Replies
Hi, mhomol
Have you tried using the connector to connect directly to powerbi or using DQ mode? It maybe helps.
Reference:
Power Query Dataverse connector | Microsoft Docs
Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Hello, mhomol Any updates?
Did I answer your question ? Please mark my reply as solution. Thank you very much.
if problem still persists, pls let me know.
Best Regards,
Community Support Team _ Janey
Unfortunately, this does not help my situation. I've got a support ticket open with MS now and will post the outcome from that.
Hi, mhomol Okay, Good luck.
