Forum Discussion
Solved
How to solve a schedule refresh problem for getting data from API?
Hi guys, I am using the below power query code for getting the data from an API. I am using a loop to get the data for many rows as the API can provide onpy 5000 rows for a call. But I am not able to...
Sorry I hadn't read your post correctly. What you need is a base URL that actually exists on the service.
https://api.genscape.com/ is not valid (the server refuses to serve that page).
Select "skip test" and ignore the error.
Hi Yash48 ,
Try the measure provided by Chris to deal with 404 error from Web.Contents:
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi Kelly,
That article was not able to solve my problem. The api url is working fine when I use in PowerBI desktop, but not when published.
Thank you,
Yash