Forum Discussion
Custom error messages?
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:
- Current error message: Error: DataFormat.Error: We couldn't parse the input provided as a DateTime value. Request ID: zzzz Activity ID: zzzz
- Custom error message: Update error: Please check the date column in the file ZZZ.xlsx (link).
Thank you.
Hi Ncio,
You can throw custom error messages from PQ like thistry (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 writeerror "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
2 Replies
Hi Ncio,
You can throw custom error messages from PQ like thistry (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 writeerror "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!
