Get data with Power BI Desktop

  Get data with Power BI Desktop

What is Power BI Desktop:-

Power BI Desktop is a free application for PCs that lets you gather, transform, and visualize your data. we can create a report and dashboard on Power Bi Dekstop and we can publish them using Power BI Services so our other team members can access that report and dashboard.

Explore a Power BI Desktop:-

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

You can connect different types of data sources in Power Bi just like on-premises databases, Excel Workbook & data from cloud services. There is almost 60 Power-Bi specific connector to cloud services such as Marketo, GitHub and many more. You can also connect data using XML, CSV, Text & Open Database Connectivity (ODBC). We can also extract tabular data directly from the website URL.

 when you want to connect to data in Power Bi Dekstop you can easily add from the option  GET DATA. this option is easily available on ribbon on the Home tab of Power BI Desktop. In the following image, you can easily see how the GET DATA option.

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.

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.