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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to select all the columns at once

Hi,

 

I'm new on Power BI  and I'm trying to change the type of datas from "text" to "number".

Here are the steps that I follow:

1. Change all the points (.) in commas (,)

2. Change the datas' type from "text" to "decimal"

 

The problem is that when I change the data source, the columns names change and i have to change manually the columns' names to match the ones that are in the new database.

e.g.:

  #"Valeur remplacée" = Table.ReplaceValue(#"Valeur remplacée2",".",",",Replacer.ReplaceText,{"Floor Area (m²) (Real)", "AE #1 Max. Flow (ac/hr) (Real)", "AE #1 Max. Flow (l/s) (Real)", "AE #1 Max. Flow (l/(s·m²)) (Real)", "AE #1 Max. Flow (l/s/person) (Real)", "AE #2 Max. Flow (ac/hr) (Real)", "AE #2 Max. Flow (l/s) (Real)", "AE #2 Max. Flow (l/(s·m²)) (Real)", "AE #2 Max. Flow (l/s/person) (Real)", "Gain 1 Max. Sensible Gain (W/m²) (Real)", "Gain 1 Max. Sensible Gain (W) (Real)"}),

 

If the new database doesn't contain the column "Floor Area (m²) (Real)", I can't execute the step "#Valeur remplacée"

 

The only solution that can help me in to select all the table instead of a list of columns.

 

Can somebody help me with this?

Thanks in advance.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Perhaps try getting rid of the Promoted Headers step and just deal with the default names of the columns? Then, promote the headers at the very end.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

Greg could have the best solution. Since the column names are changed, I, the human, don't know which column is which one if I have your data. Power BI couldn't know it either.

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Perhaps try getting rid of the Promoted Headers step and just deal with the default names of the columns? Then, promote the headers at the very end.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks a lot. I didn't notice that promoting headers will automatically detect the data type if they are in a common form.

Thanks again!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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