Table.StopFolding

Syntax

Table.StopFolding(table as table) as table

About

Prevents any downstream operations from being run against the original source of the data in table.

Example 1

Fetches data from a SQL table in a way that prevents any downstream operations from running as a query on the SQL server.

Usage

Power Query M

let
    Source = Sql.Database("SomeSQLServer", "MyDb"),
    MyTable = Source{[Item="MyTable"]}[Data],
    MyLocalTable = Table.StopFolding(MyTable)
in
    MyLocalTable

Output

table