Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MIA-27
Regular Visitor

Update master excel file connected to PowerApp Teams table

I am working on a project of data of monitoring system of machines.

 

I have a excel file called MasterDataFile having table - its data of all the machine info with some column name like Model, SerialNumber, HourMeter and Location, Its connected to Dataverse For Teams Table. 

 

Every day  I receive csv file having the update info from another team (which is a system export data), where the HourMeter and Locations gets updated of the same machines .

 

I want to update the Master excel file based on criteria - For example:

If the Model  and Serial is same - Then - Update the HourMeter and Location from the csv file.

 

Unable to understand how to start with powerquery. very much new.

Please guide

 

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @MIA-27 ,

Please follow this steps:
1.Import CSV File into Excel.
2.Once in the PowerQuery Editor, you can perform any data cleaning or transformation that your CSV data might require to make sure your CSV file has columns for Model, SerialNumber, HourMeter, and Location that can be matched with your MasterDataFile.
3.Click on Home > Merge Queries. Choose the table from your MasterDataFile and the table from the CSV file. Use the Model and SerialNumber columns (or other columns) as the keys for the merge. Select the type of join that suits your needs (likely an Inner join in this case).
After merging, you'll see the columns from your CSV file alongside the existing columns in the MasterDataFile. You can now create new columns or replace the existing HourMeter and Location columns with the corresponding columns from the CSV file. For example, you can use 

if ...... then ...... else ......

to create a new column.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much for your reply.

Tried to read your advise several times, but not able to complete the requirement,

I was able to bring side by side of the column  "service meter" of the master file and test file.

But how to automatically replace the latest data of testfile  to the master file data.

below is the screen where I am stuck:

 

MIA27_0-1707239199213.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors