Assimilating text data from multiple workbooks

Hi RhinoBane ,

You can put these excel files into the same folder, and go to Power BI Desktop, click Get Data-> Folder. You can directly combine them. Please refer to

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn

Or try to shape and combine data in Power Query after data is imported. Please refer to

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly