Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
BIuser45
Frequent Visitor

About the PowerQuery Editor Replace value feature in Power BI

I have a table as an example like this:

IDCategoryDate
1Business2023-09-20
2Education2023-09-20
3Finance2023-09-20
4Business2023-09-20
5Business2023-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? 

6 REPLIES 6
Thejeswar
Community Champion
Community Champion

@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,

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? 

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




mussaenda
Super User
Super User

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
Super User
Super User

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




RSC
Helper I
Helper I

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.