Embedding Microsoft Power BI in CXO

Table of contents:

Adding Power BI Control to CXO Report

Smart Table Structure for Embedding Power BI

Match EPM and Power BI Members

Interaction between CXO and Power BI filters

Power BI in CXO - Frequently Asked Questions

Introduction

CXO excels in data analysis of EPM systems. Embedding Power BI extends this functionality by adding additional data such as transactional or non-financial data. When transactional data is put in the EPM system to calculate P&L or Balance Sheet, while following accounting standards, transaction details get grouped. Similarly when presenting financial data, several products, entities and so on are aggregated logically under a heading to present data. However, some users need to access the transactional details next to the aggregated data. This can be achieved by embedding Power BI with CXO.

By embedding Power BI reports in CXO Dashboards you can combine transactional data and non-financial KPI's into EPM data to give an enriching overview of the company’s performance. All elements of the CXO dashboard, including the embedded Power BI report, listen to CXO’s POV. As a result, you can drill into the more finer details for both financial and non-financial data from a single dashboard.