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 all,
I have to build a table from several excel workbooks . Each of them have several sheets. The name of the workbook contanis the date of the evnts and the name of the sheet contanis the name of the company.
I should want to extract these two fieds and store them in each line of my table. I suppose this has to be done during the "get data" process. But I have no idea of how to program that.
Thank you for your help.
Regards
Solved! Go to Solution.
Hi @Anonymous ,
You can try to get data from "Folder":
[Source.Name] column is file name; [Name]column is sheet name.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can try to get data from "Folder":
[Source.Name] column is file name; [Name]column is sheet name.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Refer : https://community.powerbi.com/t5/Desktop/Add-custom-column-with-sheet-name/m-p/877507
https://community.powerbi.com/t5/Desktop/Add-a-column-with-the-sheet-name/m-p/537333
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |