Embed Power BI reports in an Excel workbook

This feature enables you to embed Power BI reports in a workbook. Then you can connect the report to the workbook selections.

When you insert a Power BI report for the first time you are prompted to log in to your Power BI account. This sets which reports to select from.

Once you've selected a report, you can set up Filters and Outputs.

Filters are sent to the Power BI report and filter the data displayed. The filter values come from Excel cells, so you can use Slicers, XL3Link, and other features to drive the report.

Outputs display the selections made in the Power BI report.

These populate Excel cells, and permit parts of the workbook to be driven from the Power BI selections.

In both cases, you must enter the Table and Column names used by Power BI. You can enter them directly, or select them from the available Tables if you have a connection to Power BI in the workbook.

You can publish the reports to the web. End users are prompted to log in to their Power BI account when the report loads.