Forum Discussion
How to debug in Power Bi Desktop
In Power Query you break the transforms into small steps. You can examine the output of each step by selecting it in the "Applied Steps" section.
You can click next to the links in your result tables to see a preview of the data behind them.
You can invoke functions and see their output based on sample parameters you provide.
Power Query allows you to throw errors if you arrive at code junctions you don't expect.For API calls you can use tools like Postman to test them out before implementing them in Power Query.
Above all - invest time learning M. It is time well spent.
Let's say you have a function that cubes a value.
(val)=> val*val*valwhen you click on the query for that function you see its details and parameters
Now you can "test" it by invoking with a sample value.
In Power Query you break the transforms into small steps. You can examine the output of each step by selecting it in the "Applied Steps" section.
You can click next to the links in your result tables to see a preview of the data behind them.
You can invoke functions and see their output based on sample parameters you provide.
Power Query allows you to throw errors if you arrive at code junctions you don't expect.
For API calls you can use tools like Postman to test them out before implementing them in Power Query.
Above all - invest time learning M. It is time well spent.
lbendlin wrote:You can invoke functions and see their output based on sample parameters you provide.
How would you invoke the function with sample parameters and see its output? I test my calls in Postman and I can click on the links and see records details once my code is executed. I am used to be able to learn language by doing small steps and seeing outputs either in the browser console or on Windows command prompt
Let's say you have a function that cubes a value.
(val)=> val*val*valwhen you click on the query for that function you see its details and parameters
Now you can "test" it by invoking with a sample value.