Forum Discussion
Use Web.contents( ) with Query & RelativePath parameters for Json Data List in Power Query M
Hello, I want to parametrize this URL using Relative Path and Query functions inside Custom M Function, here my URL and my code: URL = "http://newapi.omni.com/1.13/Omni.svc/GetRelationListJson?j...
I tried this:
Source = Json.Document(Web.Contents(URL_BODY,
[RelativePath= "GetRelationListJson",
Query =
[
json=
"{
""TypeIDs"": ""1"",
""ObjectID"":" & property_id&",
""LanguageId"": ""2"",
""CustomerName"": ""Cust"",
""CustomerPassword"": ""Pass""
}"
]
])),
It works in PBI Desktop, but I'm facing the same error in PBI Service:
[UNABLE to Combine Data] ............
Anyone can help please?