Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
11-19-2018 00:25 AM
This Power BI report is essentially to demonstrate how to use Power BI to pull data from a website and transform/clean it via PowerQuery (Query Editor). You can download the source PBI file at https://drive.google.com/file/d/1emrcWqpSnBaiYntrvV9ecnUYEcVJ9I3i/view?usp=sharing
Below are screenshots of what the source website look like and a couple of the steps I took in creating the report.
eyJrIjoiZWM1NzFlMzctM2M0Ni00ZGEzLWE0NjAtNjU5MjE2Y2ZhZTg4IiwidCI6IjgwZTlhM2Y3LTZhNTQtNDQ2OS05NTlhLWQ2MWFhNTM4Y2M4ZiIsImMiOjh9