Hi
I wanted to work on data related to the Grammy awards. From each ceremony year I wanted to import the data from 1959 to 2023. I found this list on Wikipedia 2nd Annual Grammy Awards - Wikipedia.
Is there a way of uploading this type of data into Power Query as it is not a table
Regards
Dieneba
Hi Dieneba,
You can try loading the 'Document' that comes up when you connect to a web page. This is the HTML code for the page and from there you might be able to extract the data, but it won't be easy. I had a quick look for yo and it'll be a nightmare. You'd be better off trying to find a proper list/table of the data.
Alternatively, you could try Power BI's get data from web by example feature
And scrape it from the Grammy.com site.
Mynda
Will do. You are wonderful:)
Thanks
Regards
Dieneba
