hi
i am new to Power BI. i would liek to display in my report the date of the excel file name.. ?
could you please let me know how to do it please?
thank you
You can follow the steps here to grab the name of the file: https://community.fabric.microsoft.com/t5/Desktop/adding-the-file-name-to-a-column-in-power-query/td...
And then, to extract the date, you can use Transform > extract > text between delimiters" function in Power Query, and set the start to . and the end to _, which should extract just the numbers representing the date (this obviously depends on the date format of your file, so play around with it)
You can then load that into your report.
You can follow the steps here to grab the name of the file: https://community.fabric.microsoft.com/t5/Desktop/adding-the-file-name-to-a-column-in-power-query/td...
And then, to extract the date, you can use Transform > extract > text between delimiters" function in Power Query, and set the start to . and the end to _, which should extract just the numbers representing the date (this obviously depends on the date format of your file, so play around with it)
You can then load that into your report.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
