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
Microsoft 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

priyankas's avatar
priyankas
New Member
8 years ago

Hi Dale,

 

Thank you for your reply. Here are the answers to questions you asked:

 

1. DB is SQL Server 2008

2. I have all the privilege to execute SP.

3. I can run SP from database directly.

 

Looks like it depends upon time of day when I chose to refresh PowerBI data. Today morning, during off peak time, it finished refresh quickly.

but I am still wondering, if, even during peak time when SP finishes in 7seconds, Power BI should also be able to refresh data..isn't it! ?

 

  • v-jiascu-msft's avatar
    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.

    Power_BI_Execution_Timeout_Expired2

     

    Best Regards,

    Dale

    • priyankas's avatar
      priyankas
      New Member
      8 years ago

      Hi Dale, v-jiascu-msft

       

      Yes I have SQL profiler. I will check from that next time I do refresh and it doesn't respond.

      Many Thanks for your help.

       

      Regards,

      Priyanka