Timeout on refresh

Hi RomainBiniek ,

If you are using the Import mode, th loading time depens on the size of your model (rows and columns), network status between pc and datasource, and also the performance of pc which runs the power bi. At last, calculated columns and calculated tables are computed during the database processing and then stored in the model, it will also increase the load time. You can follow this documents to optimize data model and reduse the load time.

The reasons about load time can be also the following:

1. Data Model (rows, columns, tables, you can follow this article to optimize the data model)
2. Hardware Performance (either be data source or computer running power bi desktop, check usage while importing to see if any one reach the bottleneck)
3. Network Performance(mainly when using gateway to imported into service, check the gateway bandwidth usage while refreshing)

And according to your description, you want to set the timeout property in power bi. I think there are two ways to achieve this:

First is to open the advanced options when connecting to the data source and enter the time out minutes, like this:

Second is to open the advanced editor in Power query editor and change the M query to set the time out manually, like this:

Here’s a solution that explains how to set a max run time / timeout for Power Query in detail, you can take a look and find if it’s useful:

https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query

Wish it is helpful for you!

Best regards,

Lucien