Forum Discussion
Creating a dataset from multiple excel files
Hi, I have a folder full of lots of Excel spreadsheets that I'd like to use as a dataset. I've been able to connect to it and to combine and load all of the files into PowerBI, which is really us...
Hi RachelFoulg ,
Based on your description, I checked the documentation on the issue, since you are trying to use the updated data but don't want to reload the old data, which means you have the same table structure, then you can use Append queries in power query to achieve what you want to accomplish.As this post says you can merge the old and new data sources
Solved: Adding another set of data/ spreadsheet into exist... - Microsoft Fabric Community
You can refer to this official document for more on append queries
Append queries - Power Query | Microsoft Learn
Best regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly