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

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. 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