Forum Discussion
Performance inspector for Desktop?
Is there a way to analyze performance of a Power BI query? I have a report that is quite large and has about 80 steps of transformation. Needless to say, it takes a while to load. That's ok with me as doing it in SQL isn't possible and Excel is a definite no-go. But, that said, I'd like to optimize if possible.
8 Replies
Anonymous if you have lot of steps, best would be to go thru each step and see what steps take longer. If your data source is sql server, I guess you can use profiler to see what is taking longer to load.
if performance issue is with DAX then you can DAXStudio (available free to download) to debug the expression. I hope it is helpful.
parry2k wrote:Anonymous if you have lot of steps, best would be to go thru each step and see what steps take longer.
Ah, i hadn't thought of stepping through each item. I'll give that a shot and report back. Thanks!
parry2k i'm going through the steps now and finding that all the steps that manipulate columns with text are causing the issue. There aren't a ton of them, but there are several. Any idea how to optimze those?
Anonymous what you are trying to do in the step you found is running slow?
