Forum Discussion

priyankas's avatar
priyankas
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's avatar
    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.

    Power_BI_Execution_Timeout_Expired2

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi priyankas,

 

A SP running 7 seconds won't be a problem. One SP runs 54 seconds in my test. Please check these things below.

1. What's the Database? It's SQL Server in my test.

2. Do you have enough privilege to execute a SP?

3. Can you connect to the DB with SQL Server Management Studio?

Power_BI_Execution_Timeout_Expired

 

Best Regards,

Dale