← Back to Table functions

Table.StopFolding

Prevents any subsequent processes from altering the original data source in the table.

Syntax

Table.StopFolding(table as table) as table

About

Prevents any subsequent processes from altering the original data source in the table.

Explanation

Retrieves information from a SQL table in a manner that blocks subsequent operations from executing as a query on the SQL server. Usage: Power Query Mlet Source = Sql.Database("SomeSQLServer", "MyDb"), MyTable = Source{[Item="MyTable"]}[Data], MyLocalTable = Table.StopFolding(dbo_MyTable) in MyLocalTable Output table