double quotes in weburl throws error in power bi

[vijaykaali811]

using this url in curl works fine .  how to get the same in power bi query . it says bad request 

https://xxx.com:443/e/xxx/api/v2/metrics/query?metricSelector=
(builtin:host.mem.usage:filter(and(in(\"dt.entity.host\",entitySelector(\"type(dt.entity.host),tag(app1)\")))):splitBy(\"dt.entity.host\"):avg:sort(value(max,descending))):names:
fold(avg)&from=1731543757451&to=1731550957451&resolution=30m" -H "accept: text/csv, application/json; q=0.1"
-H "Authorization: Api-Token xxx 

in power query  following is working without double quotes

https://xxx.com:443/e/xxx/api/v2/metrics/query?metricSelector=
(builtin:host.mem.usage:splitBy(dt.entity.host):avg:sort(value(max,descending))):names:
fold(avg)&from=1731543757451&to=1731550957451&resolution=30m" -H "accept: text/csv, application/json; q=0.1"
-H "Authorization: Api-Token xxx 

but using filter(and(in(\"dt.entity.host\",entitySelector(\"type(dt.entity.host),tag(app1)\")))): throws bad request 

[vijaykaali811]

thanks i got it 

[lbendlin · Accepted solution]

Please follow the documentation. Use the Query parameter. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

[ZhangKun]

use "" replace \"