Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |