Forum Discussion

gtamir's avatar
gtamir
Post Patron
7 years ago

Where are the errors?

I have 36k errors while merging 2 files. Where are they? Why an index column was added?   Giora  
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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's avatar
gtamir
Post Patron
7 years ago

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's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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