Building Reports in Excel Purchase the entire course

21 December 2018 · · 184 views

Power BI Course

Building Reports in Excel

There are two ways to connect Excel on the desktop up to data stored in Power BI: you can use the Analyse in Excel feature that was shown in an earlier section, or you can use the Power BI Publisher for Excel add-in which is probably easier to use for most users. Once you have created the connection you can use an Excel PivotTable to browse data in Power BI. PivotTables connected to Power BI data behave in a similar way to regular Excel PivotTables but there are also some useful new features such as Named Sets, Show Details. Slicers can be used as a way for users to filter the data that is shown.

The other ways to display Power BI data in Power BI is to use Excel Cube Formulas, which are well-suited for creating highly-structured reports (such as financial reports), or using Excel tables. Power View sheets are still available in Excel 2016 but they are deprecated and you should not encourage your users to use them. The 3D Maps functionality can be used to display data on a three dimensional map and there are various other Excel Add-ins and Apps that can be used to display data too.

Log in or purchase access to play the video.

  • Power BI New Features and Course Updates 1-min Free—Watch Now

  • What is Power BI? 59-min Watch with Free Subscription

  • Licensing 8-min

  • Connecting to Data Sources 42-min

  • Connecting to Data Sources (2018 Updates) 23-min

  • Data Import Concepts 55-min

  • Transforming Data with the Query Editor 1-hour 20-min

  • Transforming Data with the Query Editor (2018 Updates) 13-min

  • Advanced Data Loading 49-min

  • Modelling Data 1-hour 10-min

  • Modelling Data (2018 Updates) 14-min

  • DAX and the Data Model 31-min

  • DAX and the Data Model (2018 Updates) 10-min

  • Power BI Desktop vs Excel 37-min

  • Cloud and Desktop Power BI Dashboards and Reports 45-min

  • Power BI Reports (2018 Updates) 40-min

  • Building Reports in Excel 32-min

  • Sharing, Distribution, and Security 42-min

  • Data Refresh 8-min Free—Watch Now

  • Administration and Auditing 11-min Watch with Free Subscription

  • Azure Analysis Services 1-hour 3-min

  • Power BI Premium and Power BI Embedded 36-min Watch with Free Subscription

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo