Forum

Notifications
Clear all

Importing / replacing source data files.

1 Posts
1 Users
0 Reactions
40 Views
(@cawalawan)
Posts: 5
Active Member
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
Topic Tags
Share: