Dec 29 2020 03:08 PM
Hello,
I'm trying to load data from this website: https://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude_quotes_globex.html into a spreadsheet. Once I post the link in the Get Data From Web box and move to the next screen, the prompt goes blank. I can't see any of the data that is being previewed and can't get the data into my spreadsheet. This issue also happens with any other site I try to use. What should I do to resolve the issue? Thanks!
Dec 30 2020 09:17 AM
After Get Data From Web you shall to choose Transform. However, afraid current From Web connector in Excel is not right tool in such case, better to use one in Power BI Desktop.