Updating specific columns

[Kazzi]

I am creating a tracker that will continuously update information, such as permit status, issued date etc. 

It will be a master list with some manually entered information in each row. The master list is a power query table. I will be entering data into a data source tab, that data will be filtered and transformed into the master. To add new permits, I will either paste them at the bottom of the data source tab, and/or manually enter them into the master. 

Every couple of days, we will pull new data from our system, it will have the permit numbers, and the date it was pulled from the system, and then variable information like the status. I want to then update the status, issued date etc with this new information, but keep the manually entered rows. How would I just update specific columns without changing the manually entered rows?

[Akash_Varuna · Accepted solution]

Hi @Kazzi , Please try these 

• Use Power Query to import and clean new data from the system into a Data Source Tab.
• Merge the "Master List" and new data using a left join on Permit Number.
• Update specific columns while preserving manually entered rows.
• Refresh Power Query when new data is added to automatically update the Master List.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[v-prasare]

@Kazzi,

As we haven’t heard back from you, we wanted to check in to see if the resolution provided by our community members helps?

If you’re still facing any issues or have additional questions, please don’t hesitate to let us know.

We’re here to help and would be happy to assist further if needed. Looking forward to your feedback!

Thanks,

Prashanth Are

MS Fabric community support.

Did we answer your question? Mark post as a solution, this will help others!

If our response(s) assisted you in any way, don't forget to drop me a "Kudos"

[v-prasare]

@Kazzi, As we haven’t heard back from you, we wanted to check in to see if the resolution provided by our community members helps?

If you’re still facing any issues or have additional questions, please don’t hesitate to let us know.

We’re here to help and would be happy to assist further if needed. Looking forward to your feedback!

Thanks,

Prashanth Are

MS Fabric community support.

Did we answer your question? Mark post as a solution, this will help others!

If our response(s) assisted you in any way, don't forget to drop me a "Kudos"

[v-prasare]

Hi @Kazzi,

Thanks for reaching out MS Fabric community support.

@Omid_Motamedise, @Akash_Varuna  thanks for your promt response here.

As we haven’t heard back from you, we wanted to check in to see if the resolution provided by our community members helps?

If you’re still facing any issues or have additional questions, please don’t hesitate to let us know.

We’re here to help and would be happy to assist further if needed. Looking forward to your feedback!

Thanks,

Prashanth Are

MS Fabric community support.

Did we answer your question? Mark post as a solution, this will help others!

If our response(s) assisted you in any way, don't forget to drop me a "Kudos"

[Omid_Motamedise · Accepted solution]

Apply the Joine (Combine table) over your manuly entered table and update tdable.

[Akash_Varuna · Accepted solution]

Hi @Kazzi , Please try these 

• Use Power Query to import and clean new data from the system into a Data Source Tab.
• Merge the "Master List" and new data using a left join on Permit Number.
• Update specific columns while preserving manually entered rows.
• Refresh Power Query when new data is added to automatically update the Master List.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[Kazzi]

Hi,

I am still very new to PQ and have some questions. 

I've created a table where I add data. I've created a "cleaned data" query. Do I need a Master Query that uses "cleaned data" as a source?

Also when updating information, I can copy and paste new data into the source for the "cleaned data" and it has an independent data pulled date. Should I manually remove duplicates from that table, or should I go to "cleaned data" and remove duplicates? If so how do I make sure the older duplicates are removed and the newest are kept?