Forum Discussion

Mallory24's avatar
Mallory24
Frequent Visitor
6 years ago
Solved

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 ...
Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    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, 

ibarrau's avatar
ibarrau
Super User
6 years ago

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's avatar
    Mallory24
    Frequent Visitor
    6 years ago

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