Monkey_King24

Monkey_King24 t1_j89930o wrote

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

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

Monkey_King24 t1_j87wy9c wrote

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

You know right, that you can directly import tables and data from the web directly into power bi. There is an option called web while importing data into power bi

Clean it with power query and do any calculation needed using DAX and still make the same visual.

OR a simpler process would be directly importing the table in Excel or Google sheets, clean it and download it as CSV. To be used in Power BI

2