INTEGRATION WITH POWER BI
Combining the power of Microsoft Excel and Power BI
Experience an Excel add in that harnesses the strengths of Power BI for advanced reporting and analytics.
Connect Excel to Power BI
Connect extended Excel directly to your Power BI Data in PowerBI.com or on-premise Report Server.
Create Enhanced Dashboards
Enrich Power BI reports with custom visuals, including analytic grids, small multiple charts, and financial reports.
Get Power BI in Excel
Embed Power BI reports in any Excel workbook, maintaining data-connectivity and interactivity.
Best of Both
Avoiding the need to 'save to Excel'
Power BI is a great platform for sharing interactive Dashboards and visual reports. For more analytical use-cases, users will often export the data to Excel for analysis, which can be a tedious and cumbersome process. FluenceXL (formerly XLCubed) provides an extended model which connects Excel directly to Power BI data, avoiding the need to save into Excel, and adding a wealth of functionality over and above what’s available in PivotTables.
Build advanced reports faster
Business users quickly become productive as they can leverage existing skills while directly accessing the centralised data platform which Power BI provides, rather than creating their own data islands. Non-technical users can easily analyse the data as required, and build their own reports and visualisations benefitting from advanced ad-hoc queries, quick calculations and pixel-perfect report formatting.
CONNECT
Bringing your Power BI data into Excel
Connect directly to Power BI data models held in Power BI.com or Premium. Combine data with a wide range of sources including SAP HANA, Oracle Essbase and relational databases.
Work within a familiar design environment and leverage existing Excel skills to produce advanced and customised reports.
Try FluenceXL Excel Edition on your Power BI data today.
Connect Excel directly to Power BI data models
Ad-hoc and slice & dice analytics
User calculations with standard Excel formulae
Fine-grain control over report layout and formatting
Connect to a wide range of other sources
All FluenceXL functionality supported
CUSTOM VISUALS
Excel report integration in Power BI
FluenceXL has several Power BI Custom Visuals which help enrich Power BI reports and dashboards in a number of areas. They can all be used as a standalone report within Power BI, or configured to respond interactively with other components in the same report.
Ad-hoc analytics
Embed an FluenceXL Grid within Power BI to provide users with slice and dice analytics, drill-down and intuitive calculations.
Small multiples / trellis charting
Allows users to build multiple charts within one designer for easy comparison, and to quickly drill from one chart into many.
Formal or financial reporting
FluenceXL gives uses the layout and formatting control they need in these areas, our custom visual helps them surface these within Power BI.
Business reporting that works for you
Achieve a degree of layout and formatting control for formal reporting, alongside slice and dice analytics and ad-hoc queries, which Power BI was never intended to deliver.