I wish to import data from Web and I have tried
Data\Get Data\From Other Sources\From Web
enter Basic URL...
I am able to see the Web View but nothing in Table View (only Document in left column)
How do get around, please help.
Thank you.
I wish to import data from Web and I have tried
Data\Get Data\From Other Sources\From Web
enter Basic URL...
I am able to see the Web View but nothing in Table View (only Document in left column)
How do get around, please help.
Thank you.
What's the URL you are trying to scrape, and what does your required output look like?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I need output in table form so that I can sort / apply formulas etc, I am able to import data from wiki and sites where data
is in table form, sites such as msn.com / yahoo etc I am unable to import data
There are lots of different approaches you may take to this, depending on how the source web page is structured. Without a specific example, it's impossible to advise.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks