Forum Discussion

BIuser45's avatar
BIuser45
Frequent Visitor
2 years ago

About the PowerQuery Editor Replace value feature in Power BI

I have a table as an example like this: ID Category Date 1 Business 2023-09-20 2 Education 2023-09-20 3 Finance 2023-09-20 4 Business 2023-09-20 5 Business 2023-09-20 ...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello BIuser45,

 

So what happens in Power Query when you makee a step like replacing a value, every time you refresh the data it goes through every step so if you have new rows that should be replaced with the same concept it will replace them.

 

Mostly you don't need to have many many steps for the refresh performance, and if the transformation can be done in the datasource then do it there.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡