Viewing a single comment thread. View all comments

seamacke OP t1_j88xwik wrote

Reply to comment by Monkey_King24 in [OC] Fastest Nürburgring Nordschleife Lap Times: Production and Street Legal Cars by seamacke

That’s pretty cool, I didn’t know that you could just pull from the web in Power BI. I don’t do much direct from html stuff. I did try Excel first by just pasting the table in, but it changed the formatting (and the values!!) of the lap times, and the lap dates fields. I went back to what I know (old VBA programmer haha) and just did the cleaning in Access and then put it in Power BI. Definitely gonna try that direct from web import, that sounds cool.

1

Monkey_King24 t1_j89930o wrote

Yes a lot of people don't know this. Power BI can pull data from a lot of sources.

Here is an article that might help you for Power BI "https://www.c-sharpcorner.com/article/use-wikipedia-as-a-data-source-to-prepare-power-bi-report/"

For Excel you can use this method instead

"https://www.google.com/amp/s/www.aevotec.com/amp/training-in-a-minute-how-to-import-a-wikipedia-table-into-excel"

Also while pasting you can select the option of only the values not the format

2