Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a list of excel files. Each of them contains the following data.
Questions are the same, but columns "Customer name", "Answer" and "Comment" are repeated, and they are related to the dd.mm.yyyy column.
All I want is to associate columns "Customer name", "Answer" and "Comment" with the dd.mm.yyyy columns. Right now I just have columns dd.mm.yyyy_1, customer name_1, ....
As a result, I want to remain only 3 columns, that are associated with the different dates.
Sorry if it is not understandable. I would be grateful if you could give me some direction.
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
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..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |