Get data with Power BI Desktop


Introduction


Power BI Desktop is a free application you install on the local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them 

(often called modeling ) into a data model. This data model lets you build visuals, and collections of visuals you can share as reports, with other people inside your organization. Most users who work on business intelligence projects use Power BI Desktop to create reports, and then use the Power BI service to share their reports with others.



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.

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.

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.

Comments

Post a Comment

Popular posts from this blog

Image
INTRODUCTION TO POWER BI Microsoft Power BI is a business intelligence platform that provides non-technical business users with tools for aggregating, analyzing, visualizing, and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool that requires little upfront training. A free version of Power BI is intended for small to midsize business owners; a professional version called Power BI Plus is available for a monthly subscription fee. Users can download an application for Windows 10, called Power BI Desktop, and native mobile apps for Windows, Android and iOS devices. There is also Power BI Report Server for companies that must maintain their data and reports on-premises. That version of Power BI requires a special version of the desktop app called Power BI Desktop for Power BI Report Server. Common uses of Power BI Microsoft Power BI is used to find
Read more
Image
Model data in Power BI Introduction    Data model is a collection of loaded tables of data with one or more columns that have been loaded for a reason (don’t load any columns from your source into your model unless you have a reason). with one or more rows of data that have been loaded for a reason (don’t load rows from your source into your model unless you have a reason). relationships between the loaded tables the measures (formulas) written that apply the business rules to the raw data to extract business insights (e.g., sell price minus cost price is profit), including the formulas themselves the formatting applied to the formulas the business names were given to the formulas All of the above makeup what is referred to as “the data model” in Power BI The benefits of a data model based tool like Power BI are: the author of “the data model”  builds a reusable capability (the data model) that can be used to solve the current reporting requirements as well as (often) future requiremen
Read more