Error when loading data #NA, #REF

[ktt777]

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, 

[v-eachen-msft · Accepted 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.

[amitchandak]

@ktt777 , there should a message in yellow color in Data transformation/edit query mode about failed rows.

Open Data transformation/edit query  and check