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 all,
I have a query with many errors in a specific column, resulting from different kinds of problems. I would like to get a list of these problems in order to deal with each one specifically.
I can easily create a table containing only the rows of the query with errors, but then in order to see the specific problem for each error I have to click in the ERROR cell and see the error messages in the bottom of the screen.
This takes forever in is extremely unefficient in mass error handling. Also I can't export this table to someone working on one of the source files in excel so they can easily see what the problems are and solve them - they have to have access to my file in order to get the extra details for each error.
In order to solve this I would like to add a new column to the table containing those error messages.
I this at all possible?
Solved! Go to Solution.
What I would suggest is following -
1. Let's say the column which is having errors is called Data.
2. In a custom column, put following
=try [Data]
3. Now, it will create a column having records
4. Expand this column - This will create 2 columns - HasError and Error
HasError - True / False - You can filter on True to focus only on Error rows
Error - Will contain a record
5. Now, expand this Error record which will give all required information
What I would suggest is following -
1. Let's say the column which is having errors is called Data.
2. In a custom column, put following
=try [Data]
3. Now, it will create a column having records
4. Expand this column - This will create 2 columns - HasError and Error
HasError - True / False - You can filter on True to focus only on Error rows
Error - Will contain a record
5. Now, expand this Error record which will give all required information
Beautiful!! Thank you so much!
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.