Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.