Forum Discussion
Retrieve most updated excel file from a website without API support
Hi bleow ,
To get the contents in the download file link from web link, you can try:
1. Right click the download button, choose 'Inspect'
2. In the Inspect page, find the 'real' link of this dataset:
3. Copy this link and use the Web connector in power bi to connect it, you can get the file contents:
For more details, you can refer this article: Tips to download files from webpages in Power Query and Power BI
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply. Is there any way to do this url retrieval programmatically? My client wants as much automation as possible and doesn't want to manually check the website for dataset updates.
And in that regard, I do already have a script in the original post that does this, albeit in a hacked-together manner and I'm wondering if there's a better way to do it, or if say python/pandas integration is possible for my use case.