Forum Discussion

New Member

8 years ago

Solved

Power BI: Execution Timeout Expired

Hi, I am trying to call Stored Procedure from Power BI using Import query option. but it gives timeout error and fails to load data. Interesting thing is that when I excute same SP with same inpu...

v-jiascu-msft
8 years ago
Hi priyankas,

As you said you still can do Refresh but failed sometime. I think it could be the performance issue related to many sides. Power BI doesn't work alone. When we push Refresh, Power BI will send a request to the SQL Server 2008. But the SQL Server 2008 could say I'm busy. Some time later, Power BI could return failure message with time out.

So I think it's hard to solve this issue from Power BI side. One more thing about Refresh, Power BI sends request and gets data, the big part of the job is done in the data source.

Do you have a SQL Server Profiler? If so, you can check if the SP is executed successfully.

Best Regards,
Dale

v-jiascu-msft

Microsoft Employee

8 years ago

Hi priyankas,

As you said you still can do Refresh but failed sometime. I think it could be the performance issue related to many sides. Power BI doesn't work alone. When we push Refresh, Power BI will send a request to the SQL Server 2008. But the SQL Server 2008 could say I'm busy. Some time later, Power BI could return failure message with time out.

So I think it's hard to solve this issue from Power BI side. One more thing about Refresh, Power BI sends request and gets data, the big part of the job is done in the data source.

Do you have a SQL Server Profiler? If so, you can check if the SP is executed successfully.