Select columns of table in Power BI

[Analitika]

Hi,

I have this table definition:

let
    Source = Odbc.DataSource("dsn=MT group", [HierarchicalNavigation=true]),
    MT_GROUP_POLSKA_Database = Source{[Name="MT_GROUP_POLSKA",Kind="Database"]}[Data],
    dbo_Schema = MT_GROUP_POLSKA_Database{[Name="dbo",Kind="Schema"]}[Data],
    I03_DKD_Table = dbo_Schema{[Name="I03_DKD",Kind="Table"]}[Data]
    
in
    I03_DKD_Table

And I need to write select statement, so where to implement that?

[v-yalanwu-msft · Accepted solution]

Hi, @Analitika ;

I tested it , and in power query M language such as:

let
    Source = Sql.Database("server", "database", [Query="SELECT  [Employee]#(lf)      ,[StartDate]#(lf)      ,[EndDate]#(lf)  FROM [table].[dbo].[Table_2]"])
in
    Source

The final show:

Or you could connect sql server  in desktop.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BharathWithPBI]

Here is the help document of using Table.SelectColumns()

https://docs.microsoft.com/en-us/powerquery-m/table-selectcolumns

[BharathWithPBI]

Finally, you need to refer to the "step" which you want in output right after "in" statement
in

SelectColumns

[Analitika]

I am getting this error message:

Definition:

let
Source = Odbc.DataSource("dsn=MT group", [HierarchicalNavigation=true]),
MT_GROUP_POLSKA_Database = Source{[Name="MT_GROUP_POLSKA",Kind="Database"]}[Data],
dbo_Schema = MT_GROUP_POLSKA_Database{[Name="dbo",Kind="Schema"]}[Data],
I03_DKD_Table = dbo_Schema{[Name="I03_DKD",Kind="Table"]}[Data],
I02_DKD_Table = dbo_Schema{[Name="I02_DKH",Kind="Table"]}[Data],
SelectColumns = Table.SelectColumns ( I03_DKD_Table,I02_DKD_Table, "Select *,I02_DKH.I02_OP_DATA#(lf)#(lf)From I03_DKD#(lf)LEFT JOIN I02_DKH on I03_DKD.I03_KODAS_ZS=I02_DKH.I02_KODAS_ZS#(lf) and I03_DKD.I03_KODAS_DH=I02_DKH.I02_KODAS_DH" )
in
SelectColumns

[BharathWithPBI]

Before "in" statement

[Analitika]

I have written this but table didn't change after select statement.

let
Source = Odbc.DataSource("dsn=MT group", [HierarchicalNavigation=true]),
MT_GROUP_POLSKA_Database = Source{[Name="MT_GROUP_POLSKA",Kind="Database"]}[Data],
dbo_Schema = MT_GROUP_POLSKA_Database{[Name="dbo",Kind="Schema"]}[Data],
I03_DKD_Table = dbo_Schema{[Name="I03_DKD",Kind="Table"]}[Data],
SelectColumns = Table.SelectColumns ( I03_DKD_Table, "Select *,dbo.I02_DKH.I02_OP_DATA#(lf)#(lf)From dbo.I03_DKD#(lf)LEFT JOIN dbo.I02_DKH on dbo.I03_DKD.I03_KODAS_ZS=dbo.I02_DKH.I02_KODAS_ZS#(lf) and dbo.I03_DKD.I03_KODAS_DH=dbo.I02_DKH.I02_KODAS_DH" )
in
I03_DKD_Table

[BharathWithPBI]

Hi, 

You can use 

, SelectColumns = Table.SelectColumns ( I03_DKD_Table, <column names to select>)

in

SelectColumns

[Analitika]

But in which place? I need to write this query:

"Select *,dbo.I02_DKH.I02_OP_DATA#(lf)#(lf)From dbo.I03_DKD#(lf)LEFT JOIN dbo.I02_DKH on dbo.I03_DKD.I03_KODAS_ZS=dbo.I02_DKH.I02_KODAS_ZS#(lf) and dbo.I03_DKD.I03_KODAS_DH=dbo.I02_DKH.I02_KODAS_DH"