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.
@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem ='NAV' and NAV_Mandant='W020' and Entry_No_>",activity('LastRecW020NAV').output)
I'm using a german system. Because the where filter also need to be Sting in '' quotation marks it dosn't work.
Is there a alternative text qualifier?
Solved! Go to Solution.
Hi @MartinGeschke ,
One alternative approach is to use double single quotes to escape the single quotes within your string.
Here is the changed codes that you can have a try.
@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem =''NAV'' and NAV_Mandant=''W020'' and Entry_No_>", activity('LastRecW020NAV').output)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am trying to insert the activity error in a table in fabric datawarehouse. But because of special characters like *, ' I am unable to insert that error message into table. Any solution for this?
Hi @MartinGeschke ,
One alternative approach is to use double single quotes to escape the single quotes within your string.
Here is the changed codes that you can have a try.
@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem =''NAV'' and NAV_Mandant=''W020'' and Entry_No_>", activity('LastRecW020NAV').output)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many thanks that works!!! ''text'' double single quotes.
Can you please provide the expected SQL otput statement that you are envisioning to be executed in the database meaning Select * from xyz format.
And also what is your parameter name and a sample value of that.
Using that we would help you make it dynamic? There are 2 ways : 1 using conact and other is direct expression