Forum Discussion
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. See the error message below.
Does someone know how to solve this issue in my PBIX
Regards,
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
1 Reply
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