Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |