Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I import a bunch of file using Import folder and combine function. What I would like to do is adding the date of the import.
Let me explain . Each week a new excel file is added in this folder. This file contain volume information. What I would like is when this file is added into the dataset , powerbi would add a Column with the Date of the import. Then I know when this volume have been imported.
Any idea ?
thanks
Yo
Solved! Go to Solution.
Hi @pilsner08,
If your files are all saved on the same folder and you have on your file name the date, you should import from folder option and don't delete the column with the name file, instead use it to make it your date for that file.
Check this link with the explanation.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @pilsner08,
If your files are all saved on the same folder and you have on your file name the date, you should import from folder option and don't delete the column with the name file, instead use it to make it your date for that file.
Check this link with the explanation.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |