Custom error messages?

[Ncio]

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.

[SpartaBI · Accepted 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

     

[Ncio]

thank you!