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 experts,
Is there any way to keep the column (Date created) after extenting the Content column? I am using this exctraction to get the always the most recent files in the folder.
Solved! Go to Solution.
Hi @Anonymous ,
I understand, that the Created Date or Modified Date is not part of the file. The solution is definitelly working, at least I have no problem to extract this information.
I will try to make it step by step:
1. I have connected the folder, where I have my Excel (number 1):
2. I will use "Combine Files" on the left:
3. This will add several steps in my Query (number 2 in printscreen):
4. I will go back to Invoke function and remove the step after (number 3)
5. I will expand the table:
After step 5 I have my data and Date/Time columns as well. The other columns can be removed.
Thanks @Migasuke ! The column Transform file is is not avaialble in Power Query (Excel) only PowerBI, but I got it now.
Hi @Anonymous ,
Go to your Query and go few step back:
From here you should be able to expand the columns and keep the Date Created Column:
Please if this solved your problem, mark it as a solution!
@Migasuke Didn't work because the fiield that I need is not inside of the excel file, I am getting the file from a folder and that field is one of the fields coming with the extraction (Modified date)
Hi @Anonymous ,
I understand, that the Created Date or Modified Date is not part of the file. The solution is definitelly working, at least I have no problem to extract this information.
I will try to make it step by step:
1. I have connected the folder, where I have my Excel (number 1):
2. I will use "Combine Files" on the left:
3. This will add several steps in my Query (number 2 in printscreen):
4. I will go back to Invoke function and remove the step after (number 3)
5. I will expand the table:
After step 5 I have my data and Date/Time columns as well. The other columns can be removed.
Works perfectly with Excel.
Thank you!
Thanks @Migasuke ! The column Transform file is is not avaialble in Power Query (Excel) only PowerBI, but I got it now.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |