Get & Tranfsorm Data Not Working

New Contributor


I'm trying to load data from this website: 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!




1 Reply


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.