Forum Discussion
Solved
Updating specific columns
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 li...
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
Apply the Joine (Combine table) over your manuly entered table and update tdable.
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"