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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Unable to Remove Errors

I have a table which contains time-series data. I have errors appear in some rows, however don't seem to be able to remove them. I have tried Remove Errors, Replace Errors and Replace Values. I've even tried modifying my Power Query code to use 'Table.RemoveRowsWithErrors', however nothing seems to work. 

 

Any ideas how I can remove these rows containing Error?

error.JPG

I am using the latest version of Power BI.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I have solved this by moving the Table.RemoveRowsWithErrors() function to an earlier point in my Power Query, where the errors appear as single cells in one column (rather than expanded out to an entire row).

View solution in original post

7 REPLIES 7
Weav8060
Frequent Visitor

this is a terrible, terrible bug

Anonymous
Not applicable

I have solved this by moving the Table.RemoveRowsWithErrors() function to an earlier point in my Power Query, where the errors appear as single cells in one column (rather than expanded out to an entire row).

Anonymous
Not applicable

Same for me. Tried remove, replace errors, identifying them with try, etc. The Table.RemoveRowsWithErrors() function needs to be immediately after Source. Any later and it will not work.

This works . . .Removing Errors immediately after Sources fixes the problem. Thank You.

adityavighne
Continued Contributor
Continued Contributor

@Anonymous 

Just filter the data in by "Error" in edit query and then load/refresh the report.

Anonymous
Not applicable

Unfortunately this still did not work.

Hi!

 

I solved this by changing the API version during the data loading. I was using API version 14 and after changing this to v15 this error row was no longer there.

 

Somehow it's strange as I using in the same file v14 for other locations with no issues. 

 

Hope it helps.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.