Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fdenman
New Member

Query Errors

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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")

View solution in original post

2 REPLIES 2
fdenman
New Member

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
Super User
Super User

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")

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors