Deploying content from Excel and SSRS to Power BI
Dashboards in BI can consolidate much more than BI report visuals. Microsoft Excel objects, such as pivot tables, charts, and workbook ranges, and SSRS report items can also be pinned as dashboard tiles. This integration with Power BI allows teams to utilize existing reports and skills, and to leverage the unique capabilities of these tools as part of overall BI solutions.
In this recipe, a pivot table and pivot chart from an Excel workbook are integrated into an existing Power BI dashboard for the Australian sales team. Additionally, an SSRS report item is also pinned to this dashboard. For more advanced integration examples, see Chapter 13, Integrating Power BI with Other Applications.
Getting ready
- Install Power BI Publisher for Excel:
- See Chapter 1, Configuring Power BI Development Tools, for details on this process
- If the Power BI tab is not visible in Excel, check that the COM Add-in in Excel options is visible and enabled
- Configure Report...