Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, the problem I have is my last row has "Error" in each cell. My applied steps are:
After #3, I'm unable to load data as a PivotTable or a Table. I've tried to remove error and remove last row but that last row of errors is still there. The reason why I need #3 is because the rows duplicate themselves and I need a column in TableB for lookup.
Solved! Go to Solution.
Hi @Joiner ,
For errors in tables, you can use "Remove Errors" option.
And you also mentioned that you want to remove the last row, you can use "Remove Bottom Rows" option.
Enter 1 and click OK.
According to your description, you may swapp the position of the step in Applied Steps in Power Query, it migh cause an error. This may be because you reversed the order of the steps, causing subsequent steps to not execute correctly. If you change the order of steps, it may affect the data that subsequent steps depend on, resulting in errors.
Applied steps - Power Query | Microsoft Learn
If you are still confused, please provide some more details about the error, such as the error message or screenshots. Take care to protect your data privacy!
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Joiner ,
For errors in tables, you can use "Remove Errors" option.
And you also mentioned that you want to remove the last row, you can use "Remove Bottom Rows" option.
Enter 1 and click OK.
According to your description, you may swapp the position of the step in Applied Steps in Power Query, it migh cause an error. This may be because you reversed the order of the steps, causing subsequent steps to not execute correctly. If you change the order of steps, it may affect the data that subsequent steps depend on, resulting in errors.
Applied steps - Power Query | Microsoft Learn
If you are still confused, please provide some more details about the error, such as the error message or screenshots. Take care to protect your data privacy!
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Usually remove duplicates doesn't give any errors.
Please share the dataset.
Check out the July 2025 Power BI update to learn about new features.