Where are the errors?

[gtamir]

I have 36k errors while merging 2 files.

Where are they?

Why an index column was added?

Giora

[v-yuta-msft]

Hi gtamir,

Are you using combine files in power bi desktop to achieve one table, right? Which error message have you encountered with? Could you share more details about what you have done and the error message? In addtion, please also check if you have followed steps in the documentation: https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries.

Regards,

Jimmy Tao

[gtamir]

Thanks @v-yuta-msft

I did everything OK but I didn't notice that in one file a column was Whole Number and in the other Decimal Number.

But I am concerned of how to find the error easily. I had no error number just a notice that there are 36k errors.

How is it that the error query do not show them?

[v-yuta-msft]

Hi gtamir ,

Are there blank value or null value in your data table? If there're remove these values and check if errors still occur.

Regards,

Jimmy Tao