During refresh on PBI Service, Post Query passed as Get

[Anonymous]

Hello Everyone,

I am using Apis to fetch data into the PowerBi, the query works perfectly in PBI Desktop. Refresh is also working fine. But the same query in PBI Service is not working when making the refresh. 

I checked the Fiddler, its show as "Get" not supported for this request.  I am facing this problem only in PBI Service refresh.

Is there any workaround for this problem? Thanks in advance.  

[GilbertQ]

Hi there

If you could send more details on how you are querying the API?

[Anonymous]

Hi @GilbertQ,

Here is the Post Query code. I have tried with "RelativePath" also, but both not working in PBI Service.    

let

url = "http://localhost:8100/api/v1/Cubes('cubename')/Views('Sample')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Attributes/L01))),Cells($select=Value)",
body = "{

}",
Source = Json.Document(Web.Contents(url, [Headers=[#"Authorization"="xxxxxxxx", #"Content-Type"="application/json"], Content = Text.ToBinary(body)
])),

in 

Source

Any Workaround for this?