Forum Discussion
scheduled refresh and dynamic queries
Super UserHi. It looks like you are scrapping the pictures from the web. If you have the picture public urls, you don't need to do a web.contents url. You can just load the table with the URL and categorize that column at the data view as "Image URL" to make it display at some visuals.
If you want to scrap them, then the trick is that each picture has a URL, so how can PowerBi think about a single source if there is one by line. You can read this post to cheat on power bi letting it think the url is only one but the relative path is the different one: https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
I hope that helps,
Actually I'm not scraping from the web, that's exactly what I can't do. The localParse functions reads from a local drive, and encodes the base64 strings, but then we run into the issues described when trying to set up a scheduled refresh, and the various things I've tried to get around it.
- ibarrau
I know localParse is trying to handle base 64, but this line "each Web.Contents([Image]))" is running a web request to a string. What is Imagen? isn't that a url? that's the one I was talking about to pay attention when I was talking about scrapping.
I hope that make sense
v-menakakotaCommunity Support
- v-menakakota
Hi AnnieV ,
Can you please confirm whether the issue got resolved or not.
Thank you.- v-menakakota
Hi AnnieV ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team