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.
Hello,
One of my data source is an excel spreadsheet updated by the users. It's not very reliable and often generate error during the dataset refresh.
It's often the same steps that fails and I'd like to improve the error messages to be able to send the error report directly to the users. Is there any ways to do that?
Example:
Thank you.
Solved! Go to Solution.
Hi @Ncio,
You can throw custom error messages from PQ like this
try (StepWithPotentialError) otherwise error Error.Record("This is a custom error","I just love error messages")
try (X) otherwise Y returns X, unless X is an error. In the latter case, it returns Y.
error raises an error. You can write
error "I just love error messages"
or use a proper error record with
error Error.Record("This is a custom error","I just love error messages")
Here is the email I've got from the PBI service
Showcase Report – Contoso By SpartaBI
Hi @Ncio,
You can throw custom error messages from PQ like this
try (StepWithPotentialError) otherwise error Error.Record("This is a custom error","I just love error messages")
try (X) otherwise Y returns X, unless X is an error. In the latter case, it returns Y.
error raises an error. You can write
error "I just love error messages"
or use a proper error record with
error Error.Record("This is a custom error","I just love error messages")
Here is the email I've got from the PBI service
Showcase Report – Contoso By SpartaBI
thank you!
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.