Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 4 files in a folder. Not when i am combining those files and expanding them, date creation column is not coming up?
in simple words, how to show file creation date in power bi as column?
Solved! Go to Solution.
Hi @Anonymous,
In Power BI desktop Query Editor, after we retrieve files in SharePoint online folder, the [Date created] column displays as before before using Combine Files feature.
After we use Combine Files feature, the table shows like below:
To add a column returns [Date created] column values for each file, we can do it like below:
Best Regards,
Qiuyun Yu
In the meantime, I think, I have found a way around the problem:
When you combine Sharepoint files, Power BI automatically created "Removed Other Columns" step, which makes it only leave the Source Name. If you add "Date created" there, it's going to leave it too.
It is fast and also works if you have file with identical names (say, in different folders).
This is a much better solution. Simple and fast
Hi @Anonymous,
In Power BI desktop Query Editor, after we retrieve files in SharePoint online folder, the [Date created] column displays as before before using Combine Files feature.
After we use Combine Files feature, the table shows like below:
To add a column returns [Date created] column values for each file, we can do it like below:
Best Regards,
Qiuyun Yu
Thanks for the solution!
Although, when I tried it, it made things really slow, subsequent grouping that I needed to perform took several hours...
Is there a way to aviod that? My data is not that big, just about 80 files....
User | Count |
---|---|
86 | |
75 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |