Sep 12 2020 08:47 PM
Hello...
I am trying to import a table from https://coinpaprika.com/tag/gaming/home-overview into Excel. When i use the Import Data from Web option, no table is detected by Excel. If I try to transform the data, it takes me down a rabbit hole and still I am not able to retrieve the data.
However, when I tried the same with Power BI Desktop, the same worked perfectly.
Can anyone tell me how to import such data in excel? (Screenshots Attached)
Thank you.
Sep 13 2020 06:16 AM
Power Query for Excel is bit behind the one for Power BI Desktop. That's only wait when Web.BrowserContents will be added to Excel version.
Sep 13 2020 06:25 AM