Query Errors

[fdenman]

Ocassionally, I get query errors following a data load from an Excel spreadsheet.  I'd like to be able to generate a PBI errors report from the list of records contained in the query error table.  Is there a way to use Query Errors table as the source for my PBI report?  

Thanks very much for your assistance

[fdenman]

Thank you for such a quick reply.  In the interim, I created a query table from the dax generated by the error query, and it worked fine.  albeit this was the long approach but it did the job.  I will follow your advice and enable load. 

Thanks again for responding!

[lbendlin · Accepted solution]

Of course. Right click the query and "Enable Load". You can also have a totally autonomous process that parallels your standard query but "keeps errors"  (you should modify the original to "remove errors")