Forum Discussion
joelcochran
10 years agoMicrosoft Employee
Get data from web not showing table
Using the following URL: https://beta.fec.gov/data/elections/president/2016/ There are two tables on this page, but neither shows as a data source (but Document does): I confirmed in the...
- 10 years ago
Yeah it was the Edit button sorry, wrong translation from me.
It seems that you have to find your table into the html code.
The steps are saved on the right ribbon, if the navigation step don't increment when you navigate, you can add a random step after each click (rename columns for example). Then you can back to the previous step easily. Otherwise, you can reveal the formula bar and edit them.
ivicaSD
8 years agoFrequent Visitor
I have had the same problem, and I have found the solution:
https://datachant.com/2017/03/30/web-scraping-power-bi-excel-power-query/