"Use first row as headers" alters the column names.

[ssingh_leecare]

We have a massive dataset comprising multiple tables in csv format in an azure blob. While importing th data into powerbi, the azure blob combines and returns a single import file in powerbi, which have to be further divided into separate queries.

The steps followed for that are here: 

https://community.powerbi.com/t5/Desktop/How-to-transform-multiple-CSV-files-from-Blob-storage-witho...

NOTE: I have disabled power bi from detecting the data types on its own, thereby resulting in the column names as the first row.

On clicking the "use first row as header", Powerbi is altering the column names for at least half of the columns. I haven't been able to catch the reason behind this.

CHANGE: if the original name was xyz, then the name becomes xyz_1. (and followed by 2,3 .... after _)

Any help would be appreciated.

Thanks in advance!

[ssingh_leecare]

@Vijay_A_Verma thanks for such a fast response.

I just checked and noticed exactly what you said. 

Will get back to the community once I figure out why that happened!

[AlexisOlson]

The reason is that the column names need to be unique in Power Query. If you write TableName[ColumnName] it has to refer to a single column, not a bunch of columns.

[Vijay_A_Verma · Accepted solution]

This happens when the same column name is already existing. Hence, if you are having say 4 columns names xyz, then first will be uploaded as xyz and remaining will be suffixed with 1,2,3...

Can you check if this is the case or not?