Get data from website – Excel and Power BI

New video. Just released. Watch.

Get data from website / web page tables without copy paste. Use Power Query (Get and Transform) Web option. Copy paste just the URL. Choose the table and import. That’s it. Refresh manually or automatically while opening the file. Works with Power BI as well.

What if the web page does not have a table? For example, here we do have data, but as cards…

Data without table. Shown as cards. Example from Google play store.

No problem at all. Power BI is capable of automatically converting it to a table. Even if that does not work, you can specify few examples and extract the data as a table. Absolutely amazing. Have a look.

Queries | Comments | Suggestions | Wish list