Forum Discussion
How to associate specific columns with dates when loading data?
Hi, I have a list of excel files. Each of them contains the following data. Questions dd.mm.yyyy Customer name Answer Comment Questions are the same, but columns "Customer name", "Answer" and...
Hi,
I hope you are using Folder as a data source where you are pointing the folder path.
In a easy way, maintain the name of the column is same acorss all the files.
Ref - https://sqlitybi.com/loading-multiple-excel-files-from-a-folder-in-power-bi/
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
Thanks for your response. Yes, I'm using folders as a source.
I have lots of excel files, but the structure inside is the same. It looks like that:
But I want to gather all that data and create beautiful graphs in PowerBi. But I'm stuck with associating specific answers to specific dates..
