error message

[Anonymous]

Hello everybody!

I replaced the data I had in the excel source of my table with new data. Then, once opened PBI, after refreshing it I got the following error message. Then, once clicking on the view error link I got into the edit query view and funny enough, the data it puts in the error folder are the correct ones! While in the table below PB_Lead which is the file I wanted to replace the data I have blank rows.

Anyone knows how to fix this? How to replace the data I have in the "Errors in PB.." query to the PB... query?

Thx.

[MarcelBeug]

Somewhere in the table with errors, you must have 1 or more columns with errors.

If you click next to "Error", you will see the error message.

I would expect something like invalid data types or invalid column names.

[Sean]

I've seen this when there's TEXT now in a column of Data Type NUMBER

and just to confirm is the data in excel formatted as a table

sometimes if is not it may pull blank rows (hope this makes sense)

http://community.powerbi.com/t5/Desktop/Help-understanding-Power-BI-error-messages/m-p/110151#M46381