Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Issue
Text.Trim query folds to a statement that can't be executed by Azure Synapse. This is because Power BI uses the same logic as it does when connecting to a Sql Database, but that syntax is not supported by Azure Synapse
Power Query Code
Code generated by query folding
trim(concat(nchar(32), nchar(160), nchar(5760), nchar(8192), nchar(8193), nchar(8194), nchar(8195), nchar(8196), nchar(8197), nchar(8198), nchar(8199), nchar(8200), nchar(8201), nchar(8202), nchar(8239), nchar(8287), nchar(12288), nchar(9), nchar(10), nchar(11), nchar(12), nchar(13), nchar(133), nchar(8232), nchar(8233)) from convert(nvarchar(max), [_].[row_id])) as [t0_0],
Error Message
Syntax from Microsoft Documentation
Reproduction Steps
- Connect to an Azure Synapse Serverless Database using the Azure Synapse Analytics SQL connector (or Azure SQL database, they both use Sql.Database)
- Import a table
- Transform a Column using the built in Text.Trim Power Query transformation
Idea
Generate a query that matches the azure synapse syntax when connected to azure synapse
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.