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.
Hello I am using power query to grab the data and filenames from multiple files with different headers in some cases (all have one worksheet) into a file with one worksheet.
Is there a way where I can also grab created/modified by and if possible (a nice to have) created/modified date
thanks
Solved! Go to Solution.
I am closing this ticket. Solution was to bring the meta data using VBA
I am closing this ticket. Solution was to bring the meta data using VBA
Hello Tharun,
Thank you. However, from my checks I am not able to being created by or modified by.
Any suggestions?
@harry1605
As you can see here:
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thanks Tharun,
I understand the confusion since I am looking for the person which looking at the metadata this is Authors and Last saved by. Are you able to show this detail?
@harry1605
If I assume your are using folder connector (Folder.Contents) or sharepoint foler connector (Sharepoint.Contents), then you will be able to pull created and modified date. While loading do not click on combine data, instead click on transform data then you will be able to find those columns. Hope this answers your question.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun