About the PowerQuery Editor Replace value feature in Power BI

[BIuser45]

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

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)?

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? 

[Thejeswar]

@BIuser45 ,

Yes the Business will be replaced into Economics in the future as well.

The Performance usually depends on the steps applied to the query. Not necessarily every step slows the performance.

Regards,

[BIuser45]

How about if the current data is blank now, and I replace it ECM, does work the same way? In the future, when the tables are updated, all the blanks are replaced by ECM? 

[Idrissshatila]

Hello @BIuser45 ,

True, when the data is refreshed in Power BI it will goes through the steps in Power query every time and when it comes to the replace blank with ECM step, it will replace the blank values with ECM.

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 💡

[mussaenda]

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. 

[Idrissshatila]

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 💡

[RSC]

Hi @BIuser45,

Your Question is will PowerQuery will replace the values Automatically for future Data, 

So the Ans is YES, it will automatically update the Data, make sure when you publish the data you have applied scheduled refresh.

I begin working on Power BI since a year, what I found is, if you have a large amount of data like Millions of Rows then I think you might face a little bit of issue, otherwise it fine if you don't have that big data.