In Power BI Desktop, the Power Query Tools Are Called Get Data

April 21, 2023 - by Bill Jelen

Open Power BI Desktop. There are three main modes available as icons along the left edge of the screen.

In Power BI Desktop, there are three icons in the left margin. They are Report, Data, and Relationships. — Figure 1090. Icons along the left edge control which view you are seeing.

The Reports view starts as a large white canvas where you can build visualizations. The Data view shows the tables you've loaded. The Relationships view shows how tables or queries are connected to each other.

Power BI can load data from Excel, CSV, Access, SQL Server and many other sources. The entry point is the Get Data icon on the Home tab.

In Power BI Desktop, on the Home tab, use Get Data. — Figure 1091. If you've used Power Query in Excel, the same functionality is here.

Power BI can also load Hadoop, R scripts, or data from Quickbooks Online.

The list of supported data sources is long, including ODBC, R Script, SAP Business Warehosue Server and more. — Figure 1092. There is a long list of data sources.

This article is an excerpt from Power Excel With MrExcel

Title photo by Joanna Kosinska on Unsplash