Power BI Embedding in Excel

Revision as of 14:49, 23 October 2018 by Colin (talk | contribs) (Created page with "This feature allows you to embed Power BI reports in a workbook, and have the report connected to the workbook selections. It was introduced in Version 9.2. ==Report setu...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

This feature allows you to embed Power BI reports in a workbook, and have the report connected to the workbook selections. It was introduced in Version 9.2.

Report setup

When you insert a Power BI report for the first time you will be prompted to log in to your Power BI account. This will control which reports you can select from.

Once ou have 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 allow parts of the workbook to be driven from the Power BI selections.
Retrieved from ‘https://help.fluencexl.com/index.php?title=Power_BI_Embedding_in_Excel&oldid=8913’