Power Query How to Load Only Selected Tables in Databse

[LarsAustin]

Hi All

I'm trying to load only selected fields/columns of a big database. Below is the M code generated:

let
Source = Odbc.DataSource("dsn=hbnav01", [HierarchicalNavigation=true]),
NAVLIVE_Database = Source{[Name="NAVLIVE",Kind="Database"]}[Data],
dbo_Schema = NAVLIVE_Database{[Name="dbo",Kind="Schema"]}[Data],
Darren_ItemCardUpdate_Table = dbo_Schema{[Name="Darren_ItemCardUpdate",Kind="Table"]}[Data]
in
Darren_ItemCardUpdate_Table

This code load all tables. I only want load for example columns named "Item No_" and "Description".

How do I do that.

Thanks

Lars

 

[Norie]

Lars

Try something like this.


let
Source = Odbc.DataSource("dsn=hbnav01", [HierarchicalNavigation=true]),
NAVLIVE_Database = Source{[Name="NAVLIVE",Kind="Database"]}[Data],
dbo_Schema = NAVLIVE_Database{[Name="dbo",Kind="Schema"]}[Data],
Darren_ItemCardUpdate_Table = dbo_Schema{[Name="Darren_ItemCardUpdate",Kind="Table"]}[Data],
ItemAndDescription = Table.SelectColumns(_Darren_ItemCardUpdate,{"Item No_", "Description"})
in
ItemAndDescription

 

[LarsAustin]

Wonderful. Thanks a lot Norie!

Lars

Try something like this.


let
Source = Odbc.DataSource("dsn=hbnav01", [HierarchicalNavigation=true]),
NAVLIVE_Database = Source{[Name="NAVLIVE",Kind="Database"]}[Data],
dbo_Schema = NAVLIVE_Database{[Name="dbo",Kind="Schema"]}[Data],
Darren_ItemCardUpdate_Table = dbo_Schema{[Name="Darren_ItemCardUpdate",Kind="Table"]}[Data],
ItemAndDescription = Table.SelectColumns(_Darren_ItemCardUpdate,{"Item No_", "Description"})
in
ItemAndDescription

 

[Norie]

Did that actually work?

I'm kind of new with Power Query and was only able to test on an Access database.

 

[LarsAustin]

Hi Norie,

Your solution is 95% correct. The only thing that I changed is "_Darren_ItemCardUpdate" in "ItemAndDescription = Table.SelectColumns(_Darren_ItemCardUpdate,{"Item No_", "Description"})". I've typed in Darren_ItemCardUpdate.Table instead.

Your help is very much appreciated.

Thanks

Jojie