Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
This is what I need to be able to do
I am trying to achive the below with an Mquery:
1. First I need to run to call a REST endpoint to start the export
(modified link)
2. running the above REST endpoint, the output will look something like the below
(modified link)
https://tis.obss.io/rest/export/3kjhrqoi-asd-3rrd34-3rerwr34-94c797e9f590
I need to run the post command output to get to the data table
I managed to get to the point of writing an Mquery (screen shot) that runs successfully the first time executed (weblinks provided are modified)
However when refreshing the query, I get a 404 error: Web.Contents failed to get contents pointing to the sourcelink given in 'webdata.2'.
possible reasons that I could expect for this error is that I am missing some sort of loop that would require for checking the status of the export link..
Request generate data => status link
Loop
Request status (status link) => status, export link
exit loop when status == Succesful
Request download data (export link)
Any ideas how to include this in the query?
I would guess the url is wrong, try printing the returned url for the statusLink and check is it works without load, using the browser.
Are you able to query this new url:
statusLink1 & "/download" & "/?ApiKey
on the browser ?
Also, check this link: https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-que...
You can handle the 404 error manually and get some responses from the header.
Yes ! @camargos88
I am able to use the link in the browser and download the csv output! this is not the issue in my case
So you can try a recursive function to check if you have a return different from 404,
This link may help you: https://www.thebiccountant.com/2017/09/26/recursion-m-beginners/
Be aware you have 120 minutes to refresh it on the service, if it's more than that, you get an error.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.