Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Ok, update the highlighted section to be:
each try f_archivedEmails([id]) otherwise null
Pete
Proud to be a Datanaut!
I added the function with the menu and selected the values here.
I do not know, how and where to implement the if statement.
Can anybody give me an example?
For your scenario, i.e. running the function as a source, you could try:
(Customer as number) =>
let
Quelle =
try
Json.Document(
Web.Contents(
"https://ffbc.weclapp.com/webapp/api/v1/archivedEmail?entityId="
& Number.ToText(Customer)
& "&entityName=party&pageSize=1000"
)
)
otherwise null
in
Quelle
Pete
Proud to be a Datanaut!
Sorry I was wrong.
The number always has a value. The error come up, when the result of the function is empty. So I have to check if the result is empty and go to the next and write empty string in the columns of the query I use the function.
I think at this point, where the function will executed I have to check if the result is empty and continue with the next number.
Ok, update the highlighted section to be:
each try f_archivedEmails([id]) otherwise null
Pete
Proud to be a Datanaut!
Thanks! I found out what the reason for the error was.
But to fix it, I need to update my function that it only runs the query when the number is not null.
How can I achieve this? Tried it with if statement, but I'm pretty new and do not know how to correctly add an if statement here.
(Customer as number) =>
let
Quelle = Json.Document(Web.Contents("https://ffbc.weclapp.com/webapp/api/v1/archivedEmail?entityId=" & Number.ToText(Customer) & "&entityName=party&pageSize=1000"))
in
Quelle
I think you would apply the conditional at the point of calling the function, rather than changing the function iteself, something like:
if [Customer] <> null then myFunction([Customer]) else null
Pete
Proud to be a Datanaut!
Hi @FlorianF ,
I don't think you'll see a null in your filter list in this scenario as the cell won't be null, it will be an error value.
Try selecting your [company] column then go to the Home tab > Keep Rows > Keep Errors.
Hopefully this will leave only the rows with errors which you can review/troubleshoot as required.
Pete
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.