Viewing a single comment thread. View all comments

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

seamacke OP t1_j88xwik wrote

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