Transcend data analysis together with Power BI and Excel

Business User
Business Analyst
Microsoft Power Platform
Power BI

This module explains the different ways that Microsoft Excel users can interact with Microsoft Power BI datasets to analyze data.

Learning objectives

In this module, you will:

  • Configure a connection to Power BI datasets within Excel.
  • Learn about security configuration across applications.
  • Build Excel reports by using a Power BI dataset and cube formulas.
  • Enable Excel users to access featured tables.
  • Use new Microsoft Office 365/Excel 2016+ formulas XLOOKUP(), FILTER(), and LET().
  • Identify lineage from data source to dashboards.
  • Use Excel together with Power BI.


Microsoft Excel, PivotTables