Gaurav Saneja on 28 Jul 2016 09:39:56
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
- Comments (1)
RE: Debugg in power query
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.