Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Adding file name & path as a column attribute

Hi everyone, I'm hoping someone can assist. I'm using a SharePoint folder as a data source for a report. The folder contains XLSX files that will be added to each month, e.g.:

 

Commercials_2019.06.xlsx

Commercials_2019.07.xlsx
Commercials_2019.08.xlsx
Commercials_2019.09.xlsx

 

The table of data in each XLSX is similar to the below. I'd like to be able to add a File Path column to the tables:

 

DocIdAuthorAuthor DepartmentFile Path
400029Jimmy JamesSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029Jimmy JamesSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029Kelly kellysonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029Kelly kellysonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400029Peter PetersonServices<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400030Peter PetersonServices<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400030Petra PetrasonC-Suite<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Sarah SarahsonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Sarah SarahsonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Jimmy JamesSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Kelly kellysonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Kenny KennysonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Kenny KennysonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Mark MarksonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Mark MarksonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400035Michael HutchensServices<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx

 

This would enable me to add File Path to a slicer, to slice data based on month.

Any assistance would be appreciated.

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

You could expand the context of all the xlsx, then extract month value by Split Column in edit queries.

Then use it as a slicer.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks @v-lili6-msft  - not sure what we mean by the following?


@v-lili6-msft wrote:

You could expand the context of all the xlsx


 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.