cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Whatslife Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User
Super User

Re: How to select all the columns at once

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.

 


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

3 REPLIES 3
Super User
Super User

Re: How to select all the columns at once

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.

 


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

v-jiascu-msft Super Contributor
Super Contributor

Re: How to select all the columns at once

Hi @Whatslife,

 

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.
Whatslife Frequent Visitor
Frequent Visitor

Re: How to select all the columns at once

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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 144 members 1,970 guests
Please welcome our newest community members: