Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a custom function that queries an API for some data and loads it into a table. I plan on using this function as a column (invoke custom function) to query data from the API based on the usernames in the 1st column. Now, what I have works so far, but with some username requests to the API, it doesn't return any data. This is causing an error, and the table stops processing at the first user that kicks out an error when I try to expand the new column.
Is there any way I can handle this better in my query/function so it can keep going, and just creates null data instead of an error?
Hope this makes sense...
Solved! Go to Solution.
PQ will not automatacally handle the errors, by design. What should it do? Replace with null, replace with blank, replace with the word "Error?"
The Try/Otherwise construct is exactly for trapping errors and you could use:
try HereIsSomeMath otherwise null
and if it gets an error, it will replace with null. It is a good error handler. LIke IFERROR() in Excel.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI know it is a year late but just came across this thread when trying to debug a similar problem. I found that it works if I expand the columns when I invoke the function rather than in the function itself. Hope this helps.
Ok, well I just replaced "errors" with "null" and then expanded the table, and that worked as I had hoped. However, I'm still curious if there is a way to automate that in the query itself so I can write it into future queries to just kinda handle the errors without having to do anything
PQ will not automatacally handle the errors, by design. What should it do? Replace with null, replace with blank, replace with the word "Error?"
The Try/Otherwise construct is exactly for trapping errors and you could use:
try HereIsSomeMath otherwise null
and if it gets an error, it will replace with null. It is a good error handler. LIke IFERROR() in Excel.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNot sure how your custom function looks exactly, but have you tried the:
try ... otherwise ...
syntax?
There is an article on it here.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks, I will take a look at that one.