Table name changes when loading data

[ktt777]

Hi 

I want to load data from data to power bi. 

anyone has any idea why table name "May" become "May1" when i load the data into power bi ?

Here is the file : https://1drv.ms/x/s!ApIDnMK2eKiFgQRKyuhipNF6gWBd?e=No8uKQ

thanks. 

[dax · Accepted solution]

Hi @ktt777 ,

As @Tahreem24  mentioned, this problem is caused by duplicated name in your dataset. I find that when load your Excel In powerbi, you will have two "May" items, so powerbi rename one of them to "May 1"

When you convert corresponding area to table in sheet, and after you connect, it will show sheet and table together. You could view that your sheet name and Table name is different except "May"

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@ktt777 ,

I guess this some times happened due to already same table name is present in your model of PBI desktop.