Import John Hopkins COVID data using Power Query RRS feed

  • Question

  • I am an absolute novice in Power Query and for the past day have been trying to link John Hopkins live COVID data to excel through Power Query. I'm able to generate a JSON "get" but from there am completed lost on how to format as a singular table. Would anyone be able to help?

    Link can be found by googling ESRI COVID data then looking for the service URL for the different layers. 

    Wednesday, April 8, 2020 8:13 PM


  • Hi Tyler,

    I don't understand your request.

    Could you please provide a link to the source data and what you have done already and show where the problem lies?

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Friday, April 10, 2020 2:37 PM