Domain Identification in Power BI

book

Article ID: 192185

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

In Clarity PPM JasperSoft we have made a copy of the Project Management domain, in Power Bi how can I find it when connecting to that copy to Power BI?

Environment

CA PPM SAAS APPLICATION

Resolution

Power BI users will not be able to access the Clarity Jaspersoft domains from the Power BI application. The Advanced Reporting Domains are available to see the data using Ad Hoc Views and Reports and accessible from the Jaspersoft side. Similarly, in Power BI there is a Dataset to interact with the data.

Please keep in mind Microsoft Power BI is a 3rd party tool and Broadcom Support can only assist on the connection Clarity PPM Saas via the Odata Model.

Please see the Microsoft Power BI Documentation for complete documentation on how to interact with the data and create reports.

The following links should help you get started in creating your own Dataset.
- https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
- https://support.helpshift.com/kb/article/how-do-i-create-a-custom-report-in-power-bi/
- https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-building-reports-in-power-bi-desktop-part-7/

Additional Information

The Power BI workspace is a container for datasets, reports, and dashboards.
https://docs.microsoft.com/en-us/power-bi/fundamentals/service-basic-concepts

Power BI can be divided into three categories for how you interact with data and create reports.
1) Report view: A canvas for building and viewing reports based on the datasets defined in Data view.
2) Data view: It helps you to inspect, explore, and understand data in your Power BI Desktop model. With Data View, you’re looking at your data after it has been loaded into the model.
3) Relationships view: Identified relationships between the datasets defined in Data view. When possible, Power BI Desktop identifies the relationships automatically, but you can also define them manually.