Forum Discussion
DAX Studio and SQL profiler
Hi, I ran a refresh of a dataset for the first time. It took 4.5 hours. The main query in this is a view in SQLServer, being an aggregate on a table. When I run this view in SQLServer it takes 40...
I will lbendlin but I presume refreshing does more than only running the query in SQL ...
If you want you can show a sanitized version of your Power Query code. Unless you are doing lots of merge operations the M transforms usually take much less time than the actual source query. In any case you can use the Power Query Diagnostics options to figure that out.
