Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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,
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,
Hi @v-lid-msft ,
Wow. Perfect:) Post Query works in Power BI Service with the RelativePath as you suggesed.
Thnaks a lot.