Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a row of 'error' as values across all columns in my query editor page. It corresponds to a #DIV/0! error from a source .xlsx. Despite trying the 'remove errors' function in the dropdown in the upper left (that selects the whole table), or the 'remove errors' function in the 'remove rows' button, or selecting all the columns and right-clicking to the get the 'remove errors' choice, the row of errors still persists. What am I missing?
Some additional context, there was some transformations that were done too, including unpivots and combining multiple excel files.
Solved! Go to Solution.
The "Remove Error" function in Power Query cannot remove errors generated in Excel. Youl will have to remove the #DIV/0 in Excel before importing
The "Remove Error" function in Power Query cannot remove errors generated in Excel. Youl will have to remove the #DIV/0 in Excel before importing
Hi,
Filter any column with errors and uncheck the box for #DIV/0!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |