Table.StopFolding
Table.StopFolding(table as table) as table
Prevents any downstream operations from being run against the original source of the data in table
.
Fetches data from a SQL table in a way that prevents any downstream operations from running as a query on the SQL server.
Usage
let
Source = Sql.Database("SomeSQLServer", "MyDb"),
MyTable = Source{[Item="MyTable"]}[Data],
MyLocalTable = Table.StopFolding(dbo_MyTable)
in
MyLocalTable
Output
table