Forum Discussion
Web Connector - error 308 Permanent Redirect - issue
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
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,
2 Replies
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,
This is wonderful! Thank you so much for your help!
