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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Resident Rockstar
Resident Rockstar

@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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors