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
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
2 years ago

I will use the PowerQuery editor Replace Value feature to replace all "Business" value with "Economics". Let's say if I applied this step in PowerQuery now. In the future, if there's new data coming from a server or database after 2023-09-20 with the category Business. Will it still replace the value "Business" with "Economics" for new rows (records)?
Yes

 

Another question, I have is if I add more steps in PowerQuery editor, would PowerBI take a long time to refresh the tables and update data? 

Yes but it depends on the steps that you will add.