Category: Power Query

Export folder or file list to Excel

Export files from folder

Export the list of files contained in a folder or sub-folders has always been a difficult task. Now with Power Query this job is as easy as 1-2-3 😎😃😍 But more, if you don’t want the list of files but just the folder and sub-folders name, it’s also easy. Connect Power Query to a path …

Continue reading

Power BI with Excel

Power BI is the name gives by Microsoft to a bunch of tools to create amazing dashboard. Limitation of Excel For many people Excel is a tool that is used for its formulas, graphs or macros. I can’t blame them, I’ve worked that way myself for years. However, no one will have missed that an …

Continue reading