Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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?
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |