File name becomes Column name

[duycao]

Hi all,

This is I think a very simple staff but I've struggled with this for a while.

Basically, I connect data via the SharePoint folder. I need to update the data to that folder on a weekly basis, which means the folder contains multiple files with different names. 

Then when I load the data to Power BI, the program didn't recognize the first row as the header so I need to use "Use the first row as header" option then the "Souce.Name" will change to the file name so when I load the new file to the folder it would lead to error.

Can anyone help me on this 😞

Thank you!

[v-alq-msft]

Hi, @duycao 

Based on your descirption, I'd like to suggest you use sharepoint folder connector to connect to the folder in the sharepoint. Please make sure each file has a sheet with same name and the table in the sheet has same structure.

Result:

For further information, I'd like to suggest you refer to the document .

Best Regards

Allan

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

[duycao]

Hi, thank you for your suggestion.

I did follow the steps you suggested from the beginning but I still face this issue you can see in the below image, the program didn't take the first row as the header.

[parry2k]

@duycao what is the error?

[duycao]

The issue is, you can see the first column, its name automatically changes to the file name, then when I upload a new file to the folder it will lead to the error showing that There's no column named ABC.xlsx found in the new file