Get data with Power BI Desktop

  Introduction :-

Power BI Desktop is a free application for PCs that lets you gather, transform, and visualize your data.

Power BI Desktop and the Power BI Service work together. You can create your reports and dashboards in Power BI Desktop, and then publish them to the Power BI Service for others to consume.

The following are the tasks that you will complete in this module:

Explore Power BI Desktop

In Power BI Desktop, you'll begin to build reports in the Report view. You'll be working in five main areas:

 

1.Ribbon - Displays common tasks that are associated with reports and visualizations.

2.Report view, or canvas - Where visualizations are created and arranged. You can

   switch between Report, Data, and Model views by selecting the icons in the left column.

3.Pages tab - Located along the bottom of the page, this area is where you would select or add a report page.

4.Visualizations pane - Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.

5.Fields pane - Where query elements and filters can be dragged onto the Report view or dragged to the 

  Filters area of the Visualizations pane.

Connect to data sources

Power BI Desktop connects to many types of data sources, including local databases, worksheets, and data on cloud services. 

Connect to data

When you start Power BI Desktop, you can choose Get Data from the ribbon on the Home tab.

Combine data from multiple sources

With Power BI Desktop, you can use the Power Query Editor tool to combine data from multiple

sources into a single report.

In this unit, you will combine data from different sources by using Query Editor.

Add more data sources

To add more sources to an existing report, from the Home ribbon, select Transform data and then select New Source.

You can use many potential data sources in Power BI Desktop, including folders. By connecting to a folder, you can import data from multiple Excel or CSV files at once.