Post Query is not working in PowerBI Service at schedule refresh

[Anonymous]

Hello Everyone,

I have a Dataset which fetch the data via Rest api (POST request) from the IBM TM1 DataSource in Power Bi Desktop. It works perfectly in Power BI Desktop. After publishing the Report into Power BI Service, I would like to Schedule the Refresh for the Report.  

when I Schedule for refresh, the request always consider as GET and it fails.(checked in Fiddler)

Find the screechot below: 

How to pass the query as POST in Power BI Service? Thanks in advance

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

If you are using the complete url as the first parameter of Web.Contens such as following:

let
  Source = Web.Contents("http://XXXXXXXX/api/v1/Cubes('zPBI_SalesCube')/Views('Sample')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Attributes/L01))),Cells(select=Value)", [Content=XXXX]),
  .....,
  .....,
  FinalStep = XXX
in
  FinalStep

We can try to use RelativePath to solve it, such as following query:

let
  Source = Web.Contents("http://XXXXXXXX/api/v1/", [Content=XXXX, RelativePath = "Cubes('zPBI_SalesCube')/Views('Sample')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Attributes/L01))),Cells(select=Value)"]),
  .....,
  .....,
  FinalStep = XXX
in
  FinalStep

Best regards,

[Anonymous]

Hi @v-lid-msft ,

Wow. Perfect:) Post Query works in Power BI Service with the RelativePath as you suggesed. 

Thnaks a lot.