Forum Discussion
Changing text in a cell affect update
Hello, I was wondering if I change text in some cells (e.g. from Josh to John) can PowerBI still update all the data linked to these to cells from the original dataset (if in the original one Josh will stay Josh). I need to rename certain cells in order to link my whole model and I am using online connector for Google Analytics where I can´t rename these cells.
Thank you
Anonymous in power query, use replace the value from Josh to John, and every time data is refreshed, any data (new or old) will be replaced.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
Anonymous in power query, use replace the value from Josh to John, and every time data is refreshed, any data (new or old) will be replaced.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡