Timeout error on Dataverse Dataflow refresh

[nhigham]

Hi,

I've got two Power BI dataflows that have both started getting a timeout error when retrieving data from Power Apps Dataverse tables. They both timeout after about 10 or 11 minutes and are only trying to retrieve about 60,000 and 4,800 records from the two tables. They have worked previously, but now fail every night.

Thanks

[v-yueyunzh-msft · Accepted solution]

Hi , @nhigham 

Based on my research, The timeout error could be caused by a number of factors, including network latency, server load, or data volume. You can try optimizing the dataflows by reducing the number of columns or rows retrieved, or by filtering the data to reduce the amount of data being processed.

The Power BI Power query connector for the dataverse currently don't have the advanced "Timeout" option for a detailed timeout period to set but as you said, the data refresh timed out in around 10 minutes so that I thought there should be a advanced "Timeout" option setting in the Dataverse side that have a time out value setting for around 10 minutes, if convenient, you can feel free to check this offlcial link and go to the Dataverse side to make a check:

ServiceClient.MaxConnectionTimeout Property (Microsoft.PowerPlatform.Dataverse.Client) | Microsoft L...

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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