cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
priyankas Frequent Visitor
Frequent Visitor

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 input date parameters in database itself, it returns more than 8000 rows in less than 7 seconds.

I am wondering what could be the reason that Power BI gives timeout error.

 

PS: I tried this with latest Jan 2018 power BI version as well, but with no success !

 

Could you please help.

Many Thanks,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-jiascu-msft Super Contributor
Super Contributor

Re: Power BI: Execution Timeout Expired

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
v-jiascu-msft Super Contributor
Super Contributor

Re: Power BI: Execution Timeout Expired

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
priyankas Frequent Visitor
Frequent Visitor

Re: Power BI: Execution Timeout Expired

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 Super Contributor
Super Contributor

Re: Power BI: Execution Timeout Expired

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
priyankas Frequent Visitor
Frequent Visitor

Re: Power BI: Execution Timeout Expired

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 380 members 3,495 guests
Please welcome our newest community members: