Thread: [Solved] Power Query to get a list of folders (not files) in a location?
View Single Post
 
Old 02-17-2023, 10:23 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
No need for PowerBI, Power Query is built in to Excel since Excel 2016 and Excel 2013 can be persuaded to use it.
It's under the Data tab, Get & Transform Data.
Get Data, From File, From Folder.
Reply With Quote