Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Special holiday offer! You and a friend can attend FabCon with a BOGO code. Supplies are limited. Register now.

Debugg in power query

It would be helpful to get an option to debug the steps in power query. When I am working with large datasets power query is processing data smoothly until I apply a step inadvertently resulting in it slowing down, extremely slow like it would take 15-20 mins to refresh the query which was taking about 2-3 mins to refresh. If I could use something like step into in SQL then I can see which step is slowing it down
Status: Needs Votes
Comments
christian8
New Member
When attaching a Network monitor and tracing what queries Power BI is issuing to the Data Source (e.g. Azure Storage) I observe in a report that a large amount of repeated identical requests are filed - (in this case to return the hierarchical directory content). Debugging would help me to identify how to optimize my queries in order to reduce this network load.
fbcideas_migusr
New Member
Status changed to: Needs Votes