Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Post Query is not working in PowerBI Service at schedule refresh

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

 

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lid-msft ,

       

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

       

      Thnaks a lot.