Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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,
Happy to help!
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,
Happy to help!
This is wonderful! Thank you so much for your help!