Forum Discussion
Assistance Required: SQL Timeout Issue When Connecting Power BI
I’m encountering an issue while attempting to connect Power BI to our SQL Server database. The error message reads: “Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to com...
Pavan_123456789 in that case, the issue is for sure stored procedure that has complicated SQL logic which is slow for execution.
What i would do firstly: if you have access to SQL Management Studio, login and test this stored procedure there.
If you don't have access then contact database developer to check it on his/her side.
If it works slowly also there, the issue is stored procedure.
If it works fine and fast in SQL Management Studio, then we can check what might be the issue in Power BI.
Is it the only table in Power BI data model or maybe it has relationship to other complex tables?
Did you try to publish this dataset to Power BI Service and then to refresh it there? Does it return the same error?
Cheers,
Nemanja