Notifications
Clear all
General Excel Questions & Answers
1
Posts
1
Users
0
Reactions
40
Views
Topic starter
I have created an excel file named PeopleAnalysis. Inside PeopleAnalysis, I imported source data files called People1.xlsx and People2.xlsx. With power query I made all my transformations and loaded the data into power BI and outputted my analysis. All is good. I have end users that only know how to read the outputted analysis. However, on a regular basis we will have new source data for People1.xlsx and People2.xlsx. The content of the files will be the same with the exception that there will be more or fewer rows and the filenames will be named People3.xlsx and People4.xlsx. I would like the end user to select these two filenames and then see the updated outputted analysis. What is the best way to do this?
Posted : 17/08/2025 4:38 am