Forum Discussion
File name becomes Column name
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!
4 Replies
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
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.
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.
