Debugging options in Power BI for functions

[jasonyeung87]

Hi,

I created some functions in Power query that would (hopefully) obtain data from an API with pagination. The functions are not working properly, but the error messages I'm receiving is a bit vague. I want to debug these functions to see where they're failing, but there  doesn't appear to be anything similar to using breakpoints in Visual Studio to debug. With breakpoints, I could check which line is failing (e.g. bad code, bad variable values, etc.).

I was wondering if there are any good ways to debug user created functions in Power BI? There is the Disgnostics section in Power query editor, but it doesn't really tell me much.

Jason

[amitchandak · Accepted solution]

@jasonyeung87 , Refer if this can help

https://www.youtube.com/watch?v=iAD0ooNKV30

I usually, return step by step output and check the problem,

[jasonyeung87]

@amitchandak ,

Thanks for the link. 

Jason