This lesson will be an out-and-out Power Query lesson. In this set of videos, you will learn:
- Connecting to public websites from Power BI thru Power Query
- Fetching and pre-processing data
- Collecting data from multiple pages using Power Query functions & parameters
- Closing remarks
For the purpose of this lesson, we will be connecting to New Zealand election results website – https://electionresults.org.nz/electionresults_2017/electorate-status.html
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo
Hi, i want to connect power BI to a source (a web application) which has login credentials. Want to pull data from this portal and do visualisation in power BI. i tried but its not working and tables are blank when i give authentication details or it says invalid login. Would you be able to help me out with this. Does it require any permissions to be given in the application??
Wow! This is really awesome!
Hi Wizard of BI aka Chandoo,
I have a query (pun intended):
At 15:20 of the second video I am trying to create the function for the party table and I get a notification that my query doesn’t reference any parameters…. where have I gone wrong????
Thanks in advance.
Marcus
I can connect to the data website when I click on the link provided, yet when I instruct PowerBI to get data, Web, and paste that address, I get this error: “Unable to connect: Access to the resource is forbidden”. I’m in the US.
Hi, Did you figure out a workaround for this error? I am facing the same issue.
How can we do this to multiple sheets from the same excel?
Thanks
Hi Chandoo,
Just like other users in this classroom, I am getting the below error message when I try to load the data from the Web URL. Also, I am located in US. Please help!!
Hi Chandoo,
I can`t connect PBI to the data website, I am getting an error when I try to load from the Web URL. Could you please help?
Thank you!
Hi,
I have data in the following format for multiple studies:
Column A: UniqueID
Column B: Study name
Column C: Country name (this could be one country or multiple countries)
How can one plot a map for this kind of data?
I can connect to the data website when I click on the link provided, yet when I instruct PowerBI to get data, Web, and paste that address, I get this error: “Unable to connect: Access to the resource is forbidden”. I’m in the US. Can you help or send me the data.
Hi Chandoo,
trying to connect via web , giving the above error stating “Access to the resource is forbidden”
Please help
Hi Did Chandoo reply? we are having the same access issues?
Hi Chandoo,
trying to connect via web , giving the above error stating “Access to the resource is forbidden”
Please help
Hi Chandoo,
provided data link is not working : https://electionresults.org.nz/electionresults_2017/electorate-status.html
Can you provide an alternate link for the same data.
Please try the archived pages here:
https://archive.electionresults.govt.nz/electionresults_2017/electorate-status.html
Also try the 2020 election results:
https://archive.electionresults.govt.nz/electionresults_2020/electorate-status.html
I can connect to the website but when I provide Power BI with the URL to get the data from the website, I get this error: “Unable to connect: Access to the resource is forbidden”. I live in Germany.
The links you have provided in the comment doesn’t work as well.