Treat one power query table with 2 million rows as source for another

h_gp9
Posts: 26
Joined: Wed Jan 18, 2017 9:50 am

Treat one power query table with 2 million rows as source for another

Postby h_gp9 » Wed Nov 22, 2017 4:57 am

I have a Power Query Table named as Final Table - this table has been loaded to the Data Model. I would like to use this Table (Final Table) as a source for creating another Power Query Table but has 2 million rows.

How to call this Final table if I Can't display it in a single table but Connection Only.?
When I go to Get&Transform, From File , From Workbook only appears Name Sheet or Tables but no Connection.

Could you help me to bring data of this "Conection Only" in order to modify and modify to obtain a new query?

Thanks I advanced.

Comfy
Posts: 4
Joined: Wed May 03, 2017 1:06 am

Re: Treat one power query table with 2 million rows as source for another

Postby Comfy » Fri Aug 31, 2018 10:20 pm

In a blank query type the following:

Code: Select all

let
    Source = #"Final Table"
in
    Source


If you only need certain columns then you can use.

Code: Select all

let
    Source = Table.SelectColumns(#"Final Table",{"Column1", "Column3"})
in
    Source


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 4 guests