Automatically download data and store it to database Power BI

[Analitika]

Hello,

I would like to ask how I could download file automatically from website (.csv) file and store data to database. No need to store duplicates, newest data could be appended. Website don't share download link, just button to download file.  Get web data not works because we don't have a link.

[Anonymous · Accepted solution]

HI @Analitika,

Power bi is a reporting tool, it does not support the operations you mentioned. (power bi also does not include writeback features)  I'd like to suggest you try to use other external tools to deploy API or other types of service to do these operations.

In addition, the website button action also invokes the corresponding httprequest. For these types of requests, you need to manually trace and analyze the root request link and corresponding tokens and credentials.

Sending form data - Learn web development | MDN (mozilla.org)
Regards,

Xiaoxin Sheng

[lbendlin]

This is not something you can do in Power BI.  Use an RPA tool.