Parsing Parameter in Dataflow issue

Question

Hello All,
Good day!

I was referring the below steps for extracting data from Powerbi:
https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-2/

Now I need to update the query from EVALUATE VALUES(Date) to the below query :
Evaluate SUMMARIZECOLUMNS( 'Date'[DateDimId], 'Date'[MonthNm], "CountRows",CALCULATE(COUNTROWS('Date')))

The new query contains both single and double quotes.

This new query works fine when executed via web activity :

output:

Now the same query : "Evaluate SUMMARIZECOLUMNS( 'Date'[DateDimId], 'Date'[MonthNm], "CountRows",CALCULATE(COUNTROWS('Date')))" needs to be executed in dataflow REST API

Since it contains both single and double quotes :

we need to pass the parameter as below leveraging the escape character to resolve the parameter issue

"Evaluate SUMMARIZECOLUMNS( 'Date'[DateDimId], 'Date'[MonthNm], \"CountRows\",CALCULATE(COUNTROWS('Date')))"

But when we try about importing the projection , it fails with the below issue:

So how to handle the queries that contain both single and double quotes in dataflow activity?
What is it that I am missing out ?

Answer 1

Below will fix the issue
escape("Evaluate SUMMARIZECOLUMNS( 'Date'[DateDimId], 'Date'[MonthNm], \"CountRows\",CALCULATE(COUNTROWS('Date')))", 'json')