Lesson finished
Unlock all 27 lessons of Effective Dashboards using Power BIFull course ₹40,000 · paid
Power Query Editor, Data Connectors and Basic Table Transformation
A free lesson from Skill-Lync's Effective Dashboards using Power BI course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Week 1 Session 3”
What will you learn in this free Effective Dashboards using Power BI lesson?
Introduces the Power Query Editor, opened with Transform Data, and the Get Data connectors for files, databases, online services and scripts. Ends with a demo loading an Excel Superstore workbook, promoting first rows to headers, removing blank rows, and applying changes.
- Opening Power Query Editor with Transform Data
- Connector types for files, databases and online services
- Loading an Excel workbook with several sheets
- Using first row as header and removing blank rows
What comes after lesson 3?
Later in Skill-Lync's Effective Dashboards using Power BI course (paid): lesson 4, Week 2 Session 1; lesson 5, Week 2 Session 2; lesson 6, Week 2 Session 3. The full course has 27 lessons (7 h 26 min of video); see the course overview or its price and syllabus.
Lesson transcript
Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.
Hi all, welcome back to Effective Dashboards Building Using Power BI. In our previous sessions, we discussed about what is business intelligence, what are their functionalities, and what are the various platforms or various products available in the BI and their comparisons. And we talked about how it is Power BI, why Power BI, and how Power BI is being the market leader. And then we tried to install Power BI Desktop using Microsoft Store or using Power BI Website. In Power BI Desktop, we saw there are three views. First one is Report View. Second one is Data View. Third one is Model View or Relationship View.
So now in this session, we will talk about Introduction to Power BI Query Editor. What is Power BI Query Editor. So this will help to connect to one or many data sources. We can transform the data and shape the data so that it can be easily readable and it can be used for visualizations. So once ETL process is complete, we can load back the data to the model into the Power BI Desktop. So Power BI Query Editor is a part of Power BI Desktop only. We don't need to install any other Power Query Editor. It comes part of Power BI Desktop installation. Moving on.
So how do we navigate to the Power BI Query Editor. In your Power BI Desktop, you can see Transform Data Icon. So if you click on that icon, it will take to another window which is called Power BI Query Editor. So to get to the Power BI Query Editor. So to get to the Power BI Query Editor, select Transform Data from the Home tab of Power BI Desktop. Power Query Editor appears in the form of a blank pane ready for data where there is no data connections. Moving on. To get to the Power Query Editor, select Transform Data from the Home tab of Power BI Desktop.
So Power BI Query Editor. So Power BI Query Editor appears in the form of a blank pane ready for data when there is no data connection. Let's look into the data connectors in Power BI. So we can connect to the data from various sources with Power BI Desktop using Get Data and we can see there are so many possibilities of sources of sources like all file, database, Power Platforms, Azure Environments, Online Services and others. Moving on. Power BI can connect to any type of source data like Flat Files and Folders, Databases, Online Services and others.
So we can navigate using Power BI Desktop, Home tab, Get Data. So if we see each bucket, what all files we can access. If you see the Flat Files and Folders, we have Excel, Text Files or CSV Files, XML, JSON Files, Folder. So here we can also read data from PDF file. But don't. We will not be able to read any scanned images of the PDF. It should be the data from the PDF. We can also load files from SharePoint. When it comes to databases. When it comes to databases, we can get data from SQL Server, Oracle, IBM, DB2, MySQL, which is also a Oracle product, PostgreSQL, Teradata, SAP HANA, Amazon Redshift, Impala, Google BigQuery, Snowflake.
On your online services, we can access data from your SharePoint list. We can also get data from your Microsoft Exchange Online, Azure DevOps, basically used for Agile or Project Management from data from your Salesforce and Google Analytics. You can also get data from a website, OData feed, SharePoint list, Active Directories. You can execute your R scripts and Python scripts on your data. You can connect any database through ODBC or OLEDB. Moving on. We will have a quick demo for basic table transformation or how we can load data into the Power BI. As we discussed earlier, you can open Power BI desktop using Windows search button to open Power BI desktop and this is how it look like.
Now you see the get data. Now you see the get data. I'll put Excel workbook. I'll connect your data, a Superstore, any Superstore data and it will have like four sheets in this Excel sheet and all the four sheets will be loaded into the Power BI desktop. You see these are the orders. You see these are the orders details. Order ID, order date, order priority, quantity, sales, discount, shipment mode, how the orders, the product got shipped, what is the profit, shipping cost, this is look like a more retail data, a order data.
Now, however, you see these are the order data. However, you see these orders, we don't know the status. In the next sheet, we have a status for each order whether it is returned or not. So what is the key here? The orders, order ID, order status also has order ID. Okay. And you select the people, it will give you the manager and regency. There is a issue with the headers, right? It should be, it is coming as a rows. Basically, it should be an header and there are so many blank rows.
Okay. So these kinds of challenges we will have while loading data into Power BI desktop. Now let's quickly check how we can fix these issues using Power BI query editor. Let's load the data. Depending on your data, depending on your PC, RAM, the speed, the data processing will be fast. So it is recommended if you are using any laptop or desktop, you should have minimum 4 GB of RAM so that your data load can be faster. And you see Power BI as the intelligence. It is also seeing how much size of the data it is loading and it is trying to find the relationships. All of the data has been loaded into the Power BI desktop.
And as we discussed in the previous class, we see there is a report view. This is a blank page. You see the data view. Now we can see the data. When you click here, you can see the raw data. Right. Here also in the orders, you can see the raw data. Right. And the model, you see each table, how it is related. Right. So in this case, there is an issue with these two tables. That is why it is not related. So now to fix this, we need to go into transform data, which is Power BI query editor.
If in this, we will see on our left hand side, all the table names. And if you see here, there is a manager and region which is showing as a rows. First row should be an header. First row as a header. Now this null values are treated as blank rows. Remove blank rows. Okay. And on your right hand side. You see every step is being captured. Go to the product. You see the product name should become header. Use first row as a header. Now click close and apply. It will come back to Power BI desktop and update your data model and your report view and data view.
See all the tables is now joined based on the key columns. So this is the basic data transformation, which we can do in the. On the left hand side. On the left hand side. See all the women tab. Bye. Power BI Query Editor. Moving on, this is the demo about Power BI Query Editor Basic Table Transformation. With this, we conclude. In this session, we learned what is Business Intelligence, what are the functionalities of Business Intelligence, what are the various products of the Business Intelligence, and we discussed what is Power BI, why Power BI, how do we install Power BI, what is Power BI Query Editor, what are the various types of Power BI Data Connectors and we did a small demo about basic table transformation. With this, we will end our week 1 sessions. Thank you.