Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

timeout expired

Hello, In my PBIX file, I have 4 dim tables and 4 fact tables. The fact table take about 1.5 minutes to execute in Microsoft SQL Server Management Studio, except one that takes about 10 minutes...

Need Help

v-diye-msft
6 years ago
Hi Anonymous

1. You could set timeout option and check again. The maximum is 2 hours. The default timeout is 10 min.

2. Kindly refer to :https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

https://community.powerbi.com/t5/Service/MS-SQL-server-timeout/m-p/375307

https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/28645

v-diye-msft

Community Support

6 years ago

Hi Anonymous

1. You could set timeout option and check again. The maximum is 2 hours. The default timeout is 10 min.

2. Kindly refer to :https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

https://community.powerbi.com/t5/Service/MS-SQL-server-timeout/m-p/375307

https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/28645

Forum Discussion

timeout expired

Related content

DM_GWPipeline_Gateway_MashupDataAccessError: "Timeout expired"

SQL Execution Timeout Expired

Microsoft SQL: Execution Timeout Expired

Error Microsoft SQL: Execution Timeout Expired

Timeout expired when refreshing