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.
Hello
I am loading data from excel to power BI. some of the data is #N/A, #REF.
Will power BI skip loading rows with #NA, #REF data and continue loading otheres?
Because in Excel query, it will shows error but still loaded the row data and convert #NA and #REF to blank value
Thanks,
Solved! Go to Solution.
Hi @ktt777 ,
You could select "transform data" when you are importing an Excel file.
Then you could see some error values, you could remove rows which have error values ir replace error values as blank values.
Hi @ktt777 ,
You could select "transform data" when you are importing an Excel file.
Then you could see some error values, you could remove rows which have error values ir replace error values as blank values.
@ktt777 , there should a message in yellow color in Data transformation/edit query mode about failed rows.
Open Data transformation/edit query and check
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |