Push Datasets - double quotes in JSON Values

Anonymous — Mon, 08 Jun 2020 18:02:13 GMT

Hello - I'm using the PostDataset from the Reset API to create a dataset in PBI service. I'm trying to create a calculated field which contains double quotes. However it's not working because the double quotes are being interpated as the end of the value. Below is an alterved version of the request body i'm using, where the red highlight is where i'm running into an error.

{
"name": "DatasetNew",
"tables": [
{
"name": "TableA",

.......

"measures": [
{
"name":"Avail",
"expression": "SWITCH(TRUE(),VALUES('SWITCH Table'[Dataset]) = "Day", [DaysSum],v0 )"
}
]

}

]
}

https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_postdatasetingroup

Re: Push Datasets - double quotes in JSON Values

lbendlin — Mon, 08 Jun 2020 22:20:59 GMT

have you tried backslash escaping? \"Day\"

topic Push Datasets - double quotes in JSON Values in Developer

Push Datasets - double quotes in JSON Values

Re: Push Datasets - double quotes in JSON Values