Power BI: How to Combine Multiple Excel Files in one table

In this video I am going to show you how to work with multiple #excel files saved either in your local drive in a folder or in a #sharepointonline library folder, in #powerbi.

In this scenario, every month a new sales Excel file is saved in one of the above mentioned locations. The goal is to automatically and dynamically bring that data into one table in Power BI. For that, the different Excel files will have to be combined and merged. Lets see what we need to prepare and how to achieve that in Power BI.

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here:
   • Power Automate & SharePoint Online - ...  

Feel Free to follow me on other social media platforms as well:
https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj