- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

SelectColumn in Dataflow
Hi guys,
I'm using dataflow to do all data transformations. I would like to create a table by retreiving data from a column of another table (A) so I tried table.selectcolumn but I think it is not available in a dataflow because firtsly there is not suggestion of the formula and secondly I wrote the whole instruction and it's wrong.
To optimize the performance, I want to avoid to take all data of the table A and then remove all useless column. Do you have any idea how could I do that ?
Thank you in advance !
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello - select columns is available in dataflows. I've included a sample below. Please replace the table and column names with those from your data.
Table.SelectColumns(table,{"Column1","Column2"})
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello - select columns is available in dataflows. I've included a sample below. Please replace the table and column names with those from your data.
Table.SelectColumns(table,{"Column1","Column2"})
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-05-2025 06:29 AM | |||
Anonymous
| 06-06-2023 05:40 AM | ||
05-23-2025 08:02 AM | |||
Anonymous
| 02-14-2021 11:48 AM | ||
03-09-2016 07:34 PM |