Difference between revisions of "Power BI Embedding in Excel"

(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...")
 
Line 9: Line 9:
 
* Outputs display the selections made in the Power BI 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.
 
** These populate Excel cells, and allow 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. These can be typed in directly, or picked from the available Tables if you have a connection to Power BI in the workbook.
 +
 +
[[Image:PowerBIFilter.PNG|500px|centre]]

Revision as of 14:59, 23 October 2018

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.

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

PowerBIFilter.PNG
Retrieved from ‘https://help.fluencexl.com/index.php?title=Power_BI_Embedding_in_Excel&oldid=8914’