Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ssingh_leecare
Frequent Visitor

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

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!

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

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?

View solution in original post

3 REPLIES 3
ssingh_leecare
Frequent Visitor

@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!

 

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
Super User
Super User

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?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors