Timeout from Dataverse

[mhomol]

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?

[v-janeyg-msft]

 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

[mhomol]

Unfortunately, this does not help my situation. I've got a support ticket open with MS now and will post the outcome from that.

[v-janeyg-msft]

Hi, @mhomol  Okay, Good luck.

[v-janeyg-msft]

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