Get data from a web download page

[bdpierce]

I am trying to connect to publicly available data on a webpage that allows the user to make selections and then download the data as a .csv file. The challenge is that the webpage does not present the data in tabular form, so Power BI's "Get data from web" option doesn't work. Since this is a continuous time series of stream flow data, I would like to be able to connect my Power BI report directly to the data source so I can refresh it without having to manually download the data.

Here's the url: https://green2.kingcounty.gov/hydrology/DataDownload.aspx?G_ID=1609&Parameter=Stream%20Flow

(I use the 15 minute reporting interval and the start and end dates that automatically propogate as the first and last date in the dataset)

I thought perhaps an API could be used, but I have not been able to figure out how to do so. My aplogies if I am missing something obvious, I'm fairly new to Power BI.

Thanks for any advice!

[bdpierce]

Thanks for your response. I confirmed with the data owners that there is no API, so it seems like Power Automate may be my best solution.

[AlexisOlson · Accepted solution]

This isn't necessarily possible without using another tool. If the site doesn't have an API you can use, you may be limited to the export method that they do make available.

You might want to check out Power Automate to automate the exporting process if that's indeed the only option.