Data for this report could not be fetched in the allocated time.

[PowerBIOrg]

Hi All,

I experienced this issue when the report is running up to 10 minutes (600 seconds). 

 I read the statement from here, it mentioned "For Paginated Reports in Power BI, the default value is set to 600 seconds." and "Users who have permission to modify the properties of a published report can reset this value by editing the report definition file.".  

I had set time out value of all the dataset properties to 0. 

Is there anyone know how to edit the value? I would like to set to no timeout.

Thanks

[v-henryk-mstf]

Hi @PowerBIOrg ,

According to the documentation, to not specify a timeout value, use 0. There is no problem with the associated error message. If you set the time to another value, does it report an error?

Also can you provide more information about the data source or configuration, so that I can do further troubleshooting.

Looking forward to your feedback.

Best Regards,
Henry

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

[PowerBIOrg · Accepted solution]

Hi Henry,

In the Power BI Report Builder, the timeout value in the Dataset Properties is 0 by default. But I found that  there is no Timeout element in the RDL code.

So I add <Timeout>0</Timeout> after the <CommandText> element. 

When I open the RDL file and publish to Power BI service, the timeout element will disappear from the code.

I just can change from 0 to higher timeout value (eg: 43200s = 12 hrs) to make it works longer than 10 minutes. 

[PowerBIOrg]

Hi Henry, 

I set the time out value to 0 for all the datasets and also set the connect timeout to 0 as the following data source configuration, yet I still get the error when it run til 10 minutes.