Forum Discussion
SQL Statement Fast in SQL Management Studio - and Very Slow in Power BI
Hello All, I am new to power bi. I am using a SQL statement to pull data into our model. This SQL statement takes 10 seconds to complete in SQL Server Management Studio; However it is taking about ...
Hi joeforpowerbi,
I agree with Arentir. I would propose to run SQL Profiler tracing two times:
1) Run your query in SSMS query and save a trace of it.
2) Run refresh of the report and save this trace as well.
And then compare both.
P.S. If your database is in Azure then you need to use Extended Events
About SQL Server Profiler - https://www.youtube.com/watch?v=mJ8Dyv4Uk6E
Extended Events - https://www.youtube.com/watch?v=qqqJeC8u6cA
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!