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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Cant See Query Errors In Power Query

I have a table that I load data into weekly, occasionally there are errors when I try to load, but when this occurs and I click "View Errors", the errors are not visible in Power Query.

 

I think this may be because I deleted the query group that displayed errors before.  If so, how do I re enable the errors to show in power query when they occur during data load?

 

jjanecm_0-1640092559038.png

 

Mark Janecek 

PTP Metrics Analyst

3 REPLIES 3
MFelix
Super User
Super User

Hi @Anonymous ,

 

The error codes are regenerate at each "refresh" of the data so they should appear.

 

One way to force it to appear just go to the query that has errors and make a small change (add a new step to your query) for example changing a name, renaming or making a sorting then when the model reuploads should return the error query,

 

After checking the errors just delete the step you added.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

I am going through a similar scenario, and repeated the above instructions. However, I am not seeing the error query return.

Hi @Anonymous ,

 

Is it not returning any errors anymore?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.