Can power query or power bi read error logs?

[Anonymous]

There have been a few major bottlenecks with using power query at my organization. One of them is the inability to read error logs from old excel workbooks, oracle databases.

In other words, is there a way to get power query or power BI to do:

1. Delay evaluation of error for a text field on load.  Then do an operation on the data that is multipart ifelse statment or  regular expression on the raw ascii that would normally give it an error.  The concept of delay evaluation is a bit more advanced then simple find and replace because it based trying to account for concept of missing not at random in sparse data: https://en.wikipedia.org/wiki/Missing_data#:~:text=Missing%20not%20at%20random%20(MNAR,to%20the%20re...
2. Ignore all errors on a test field until the final step.  In other words to treat unicode as pure unicode with no formating or any a changes. 

Often time I find myself having to us other tools such as SQL, python, R, and more do so what should be a simple operation.  

Has there been any progress on this front for allow users to read error logs in Power Query or Power BI? 

Related as this is what the query normally does:

https://community.powerbi.com/t5/Desktop/DataFormat-Error-Invalid-cell-value-N-A/m-p/366341

https://community.powerbi.com/t5/Power-Query/Importing-excel-data-that-contains-N-A-values/td-p/9115...

[v-jingzhang]

Hi @Anonymous 

Based on my research, I haven't found a way to ignore all errors until the final step. For cell-level errors, sometimes the steps after them can be applied because these errors only happen on some cells not on the whole column. But for step-level error, it is difficult.

You can use try ... otherwise ... syntax to deal with errors, however this will not record the error messages. 

https://docs.microsoft.com/power-query/error-handling

https://docs.microsoft.com/power-query/dealing-with-errors 

I found two blogs about error handling. Not sure if they would be helpful.

https://www.clearpeaks.com/how-to-handle-data-errors-in-power-bi/ 

https://bengribaudo.com/blog/2020/01/15/4883/power-query-m-primer-part-15-error-handling 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.