SQL Query not loading in Power BI: Unable to connect

[Anonymous]

Hi guys,

im trying to load an SQL query in Power BI. The Query works with SQL Management Studio and takes 7 minutes to load. But once i execute in Power BI it takes very long and eventually error message comes: 

They query has some declare statements in the beginning: 

Other than that only some joins and subselects. 

Any body an idea why it does not load?

Thx

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may modify the command timeout parameter to work through this issue.

Best Regards,

Jay

[HotChilli]

The error message says it timed out.

We can't offer advice on the query because the picture only shows some variable declarations.  We need to see the query (and even then this will probably involve tuning the query and indexes in SQL Server before powerbi gets involved)