Combine multiple table to one on Power Query

Hi Jouworld 

What is the data source of all 48 tables? If they are files like Excel, TXT, CSV .etc and stored in the same folder, you can use Folder connector to connect to this folder and combine all files into one query. After combining files, there is a new "Source.Name" column in that combined query. The Source.Name column indicates that from which file every row is getting data. 

Reference:

Folder 

Combine files 

Import all CSV files from a folder with their filenames in Power BI 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.