Archived post from 2017. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.
Last month the Power BI team at Microsoft released an enhanced “combine binaries” experience, that I covered here last month. That new functionality allows you to easily combine multiple CSV files (and other file types) from a folder and utilize…
Belinda Allen is big fan of this.
Import all CSV files from a folder with their filenames in Excel – PowerPivotPro