Taking too long to evaluate query from SQL Server

[Ibad_Khan]

Hello PBI Community, hope you all are doing good.

When I'm executing query in SQL, it takes 4 to 5 minutes to fetch records but when I use same query in Power BI to load data, it takes almost 10 to 15 minutes in evaluting and then 5 to 10 minutes it shows waiting for connection. 

FYI I'm attaching screenshots of both screens.

Looking forward for some positive responce.

[v-xiaotang]

Hi @Ibad_Khan 

Thanks for reaching out to us.

Please read the documentation about this: My dataset is taking too long to refresh! | by dataninja | DataDrivenInvestor

Please try these settings according to that article, 

and read this part

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.