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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Daniell1
New Member

Table.TransformColumnNames(PreviousStep, Text.Lower)

I have two sources (Dierct Queries) in Power BI, which I want to use interchangably. All column names in the first source are written in lower case, while in the other one the same tables and column names are written in the Upper Case. I found that I can use Table.TransformColumnNames(PreviousStep, Text.Lower) to lower the the letters in the second source. My question is how it impacts the performance?

1 ACCEPTED SOLUTION
v-karpurapud
Community Support
Community Support

Hello @Daniell1 

Thank you @GilbertQ for your prompt response!


Thank you for contacting the Microsoft Fabric community. We understand you are looking for insights into the performance impact of the Table.TransformColumnNames transformation in Power BI.

 

Using Table.TransformColumnNames(PreviousStep, Text.Lower) to standardize column names across two data sources typically has minimal performance impact. As this transformation is applied at the Power Query level, it does not create additional database queries. The process is limited to renaming column headers, making it lightweight compared to more complex transformations like merging or aggregating data.

 

However, in scenarios where the query is complex or the transformation is combined with multiple steps, Power BI may generate additional SQL queries to rename columns before executing the main query. This can potentially increase query execution time, especially when dealing with large datasets or when multiple transformations are applied sequentially.

 


If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

 

Thank you!





View solution in original post

2 REPLIES 2
v-karpurapud
Community Support
Community Support

Hello @Daniell1 

Thank you @GilbertQ for your prompt response!


Thank you for contacting the Microsoft Fabric community. We understand you are looking for insights into the performance impact of the Table.TransformColumnNames transformation in Power BI.

 

Using Table.TransformColumnNames(PreviousStep, Text.Lower) to standardize column names across two data sources typically has minimal performance impact. As this transformation is applied at the Power Query level, it does not create additional database queries. The process is limited to renaming column headers, making it lightweight compared to more complex transformations like merging or aggregating data.

 

However, in scenarios where the query is complex or the transformation is combined with multiple steps, Power BI may generate additional SQL queries to rename columns before executing the main query. This can potentially increase query execution time, especially when dealing with large datasets or when multiple transformations are applied sequentially.

 


If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

 

Thank you!





GilbertQ
Super User
Super User

Hi @Daniell1 

 

As always, this depends on the data source that you are connecting to. And the only way I can recommend knowing what the impact will be to performance is is to try it out and measure the performance to see how it will change.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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