Forum Discussion
Post Patronseeking ideas - getting data from the web
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.
lastnn30 , You can check for Open data
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/?%24deep_link=true&correlation_id=a30e0763-ec98-438f-80e2-e82ff2e444dd&post_fullname=t3_uepmk7&post_index=1&ref=email_digest&ref_campaign=email_digest&ref_source=email&utm_content=post_body&%243p=e_as&_branch_match_id=1001379758426881119&utm_medium=Email%20Amazon%20SES&_branch_referrer=H4sIAAAAAAAAA22P22rDMBBEv8Z986WWSNxCKC2l0Lf%2BwaJIa2exbuiCm7%2FvumneChIMZ5id3UspMT%2F3fUJjqHQqxs6SX3sRX5pRinhCUPmBZUi0kFcWarKny55qxGszfvDbtq37y%2BvgGCT%2BX2HD9PbJiplDXzLLitGtRxYEyoGuKbFhr2BRJU9%2Bgbin4My2N7CFag1YWnHvEVwlDWKEfcFGvJdU2TjowFOsKhQ8kGGuxIDD8SBa1E9TK8U0t9OAY4vTOM8jSimN4VwMucBcrfXK4T5OwH29m0fe4DcbjwwSzqzQKbJgaMFcbhC0clHR4v93c6hJ491jWAufHXzhs5n%2B1pyDuf4AEGvvCoYBAAA%3DHi 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.
2 Replies
- amitchandak
Super User
lastnn30 , You can check for Open data
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/?%24deep_link=true&correlation_id=a30e0763-ec98-438f-80e2-e82ff2e444dd&post_fullname=t3_uepmk7&post_index=1&ref=email_digest&ref_campaign=email_digest&ref_source=email&utm_content=post_body&%243p=e_as&_branch_match_id=1001379758426881119&utm_medium=Email%20Amazon%20SES&_branch_referrer=H4sIAAAAAAAAA22P22rDMBBEv8Z986WWSNxCKC2l0Lf%2BwaJIa2exbuiCm7%2FvumneChIMZ5id3UspMT%2F3fUJjqHQqxs6SX3sRX5pRinhCUPmBZUi0kFcWarKny55qxGszfvDbtq37y%2BvgGCT%2BX2HD9PbJiplDXzLLitGtRxYEyoGuKbFhr2BRJU9%2Bgbin4My2N7CFag1YWnHvEVwlDWKEfcFGvJdU2TjowFOsKhQ8kGGuxIDD8SBa1E9TK8U0t9OAY4vTOM8jSimN4VwMucBcrfXK4T5OwH29m0fe4DcbjwwSzqzQKbJgaMFcbhC0clHR4v93c6hJ491jWAufHXzhs5n%2B1pyDuf4AEGvvCoYBAAA%3D 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.