Forum Discussion
Taking too long to evaluate query from SQL Server
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.
1 Reply
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.
