Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

During refresh on PBI Service, Post Query passed as Get

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.  

 

 

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    If you could send more details on how you are querying the API?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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?