We faced an issue with "-" in query parameter. It works fine until you publish the reports. e.g. [Query=[page-id=Text.From(pageid)]] throws an error.
v-haibl-msft, yes, if we do not use "-" in query parameter it works. But the API we need to consume has a parameter with "-" in it and we dont have an option to get it updated by the API owners. Do we have a work around for this?
On the other hand if we use the below syntax, it doesn't work when we publish the PBIX to web.
Source = Json.Document(Web.Contents("http://dbbackups.cloudapp.net:8077/api/Project/GetQueryParameterInformation?Project-Id=5")