Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI. With this approach, merging will continue even if new sheets with new tables will be created in the future.
R programming, Excel, DAX, Power BI
Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI. With this approach, merging will continue even if new sheets with new tables will be created in the future.