seeking ideas - getting data from the web

[lastnn30]

Hi

I am learning how to use Power BI/Power Query to get data from the internet, clean it and analyze it using some simple visuals. I am trying to avoid using DAX for now. Just simple cleaning and analyzing data. I did my google search but most of example is how to get World population and us map visual etc. Frankly, it is not usueful because these kind of table already in the internet. I am looking for something different to learn form. Any idea please? Thank you very much.

[amitchandak · Accepted solution]

@lastnn30 , You can check for Open data

https://powerbi.microsoft.com/it-it/blog/worldwide-demographics-amp-statistics-using-power-query-and...

https://data.world/datasets/power-bi

Power BI dataset
https://www.mssqltips.com/sqlservertip/6155/power-bi-datasets/
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
https://www.reddit.com/r/PowerBI/comments/uepmk7/i_am_currently_learning_power_bi_and_would_like/?%2...

[Anonymous · Accepted solution]

Hi @lastnn30 ,

Based on this: Frankly, it is not usueful because these kind of table already in the internet. I am looking for something different to learn form. 

If you want to learn something about data transformation/visulaizations, you may refer to: 

Data Loading And Transformation Best Practices - Enterprise DNA

Top 30 Power BI Visuals List & Chart Types Explained *2022

Or if you want to extract data on Web pages aren't in tidy tables , please use Extract data from a Web page by example in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@lastnn30 , You can check for Open data

https://powerbi.microsoft.com/it-it/blog/worldwide-demographics-amp-statistics-using-power-query-and...

https://data.world/datasets/power-bi

Power BI dataset
https://www.mssqltips.com/sqlservertip/6155/power-bi-datasets/
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
https://www.reddit.com/r/PowerBI/comments/uepmk7/i_am_currently_learning_power_bi_and_would_like/?%2...