Web Connector - error 308 Permanent Redirect - issue

[Mallory24]

Hello fellow PowerBI nerds, 

I have to include in my dashboard the number of Covid-19 cases and deaths in England by Region. Therefore, I have been trying to conenct to the 2 CSV files available on UK Gov website: https://coronavirus.data.gov.uk/ . If you click on the links you will be able to see the CSV are downloading fine and have data.

I have used the Web Conector in Power BI and I am getting the error below. I've been looking online for answers on how I can deal with this but I didn't find anything useful yet. Has anyone experience anything like this before? Is this not a PBI issue but a problem with their website? Would I have to get in touch with them?  

Any help would be appreciated!!!

"DataSource.Error: Web.Contents failed to get contents from 'https://coronavirus.data.gov.uk/downloads/csv/coronavirus-cases_latest.csv' (308): Permanent Redirect
Details:
DataSourceKind=Web
DataSourcePath=https://coronavirus.data.gov.uk/downloads/csv/coronavirus-cases_latest.csv
Url=https://coronavirus.data.gov.uk/downloads/csv/coronavirus-cases_latest.csv"

Thanks,

Mal

[ibarrau · Accepted solution]

Hi. The problem is in the address. It is redirecting to another one. You should give Power Bi the last URL with the download.

Try this:

= Csv.Document(Web.Contents("https://c19downloads.azureedge.net/downloads/csv/coronavirus-cases_latest.csv"),[Delimiter=",", Columns=19, Encoding=1252, QuoteStyle=QuoteStyle.None])

That one should work. In order to get it you can go to "Downloads" in your browser and check the address.

Regards, 

[Mallory24]

This is wonderful! Thank you so much for your help!