The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
19 | |
18 | |
16 | |
13 |