We are trying to delete all rows in a SQL Table where ToDelete=true. There are about 8 rows that meet this criteria.
The following code does not remove any rows from SQL Server:
RemoveIf('[dbo].[Material]',ToDeleted = true)
Is there something wrong with the syntax ?
Go to Solution.
The RemoveIf doesn't work on tables.
The correct syntax is:
Remove('[dbo].[Material]',Filter('[dbo].[Material]',IsDeleted = true));
View solution in original post
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand