Đọc bằng tiếng Anh

Chia sẻ qua


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