Using folder attribute in report

[Caitlin_Knox]

I'm not sure if this is possible or not. I have a local folder configured as a data source in my pbix file and would like to use an attribute in that folder in my report. Specifically, I'd like to be able to display when the folder was last modified. Is this even possible?

[Datatouille]

Hi @Caitlin_Knox

You normally have this information in the Power Query editor when you import data from a folder: http://www.girlswithpowertools.com/2014/05/inventory/.

The article shows Power Query in Excel but it is exactly the same behavior in Power BI Desktop.

[Caitlin_Knox]

I do see it when I navigate to source, but once the binaries are combined, the only attribute that remains is the name of the workbook in that folder. How can I keep that column?

 

[Datatouille]

I'd copy the query and only keep the "source" step. You'd have your current table with the data you want to analyse + a table which indicates the lastmodified date.

There might be better approaches (maybe with Power Query/M..) which I am not aware of 🙂