Transform data into actionable insights with dashboards and reports.
Power BI Desktop enables you to transform data into actionable insights with dashboards and reports. It is built for the analyst and combines state-of-the-art interactive visualizations, with industry-leading data query and modeling built-in. Create and publish your reports to Power BI. Power BI Desktop helps you empower others with timely critical insights, anytime, anywhere.
Visually explore your data through a free-form drag-and-drop canvas, a broad range of modern data visualizations, and an easy-to-use report authoring experience. With the Microsoft on-premises data gateways, you can keep your data fresh by connecting to your on-premises data sources without the need to move the data.
Connect, mash up and model, and visualize your data. Place visuals exactly where you want them, analyze and explore your data, and share content with your team by publishing to the Power BI web service. Deploy and distribute interactive Power BI reports—and traditional paginated reports—within the boundaries of your organization’s firewall through On-premises reporting with Power BI Report Server.
The Power BI Desktop makes discovering data easy. You can import data from a wide variety of data sources. After you connect to a data source, you can shape the data to match your analysis and reporting needs.
Create relationships and enrich your data model with new measures and data formats
When you import two or more tables, oftentimes you’ll need to create relationships between those tables. The Power BI Desktop includes the Manage Relationships dialog and the Relationships view, where you can use Autodetect to let the Power BI Desktop find and create any relationships, or you can create them yourself. You can also very easily create your own measures and calculations or customize data formats and categories to enrich your data for additional insights.
The Power BI Desktop includes the Report View. Select the fields you want, add filters, choose from dozens of visualizations, format your reports with custom colors, gradients and several other options. The Report View gives you the same great report and visualizations tools just like when creating a report on PowerBI.com.
Save your reports
With the Power BI Desktop, you can save your work as a Power BI Desktop file. Power BI Desktop files have a .pbix extension.
Upload or Publish your reports
You can upload the reports you created and saved in the Desktop to your Power BI site. You can also publish them to Power BI right from Power BI Desktop.