The Obzervr Data Cube is a Power BI Semantic Model Dataset for Obzervr users.
This dataset provides a data model that contains all data collected and configured in Obzervr. Users can use this dataset to build customised Power BI reports with minimal efforts. The tables and measures are designed and created following best practices, sample reports of how to use this dataset are also provided.
Analytics Pipeline Architecture
The Obzervr Data Cube can be deployed in Obzervr Power BI Workspace, customer’s Power BI workspace or deployed as a Template App. The ways to acquire access is slightly different, please see the details below
Obzervr’s Power BI Workspace
A set of reports is built on top of the data cube and end users usually access these reports via Obzervr Analytic portal.
Additional requests and configurations are required if an external Power BI user requires direct read access to the Obzervr Data Cube. Please see the guide below
https://lytix.be/cross-tenant-data-sharing-with-power-bi-a-comprehensive-guide/
External Organisation Power BI workspace
External organisation workspace admin fully controls the Data Cube access once published. Please note that the analytic database credentials must be configured for dataset refresh.
Please note that API account/service principal credential details need to be provided to Obzervr if the dataset refresh is required to be triggered by the analytic data pipeline
Template App
Obzervr also provides an option to deploy Obzervr Data Cube via the template app. A workspace and dataset will be created automatically once the app is installed. The access and data source configurations are the same as the previous one.
The Obzervr Data Cube template app is available in the Microsoft Marketplace here. Please note that additional permission is required to install a template app that is not published.
<aside> 🔗
https://appsource.microsoft.com/en-us/product/power-bi/obzervr.obzervr_data_cube
</aside>
SQL Server: Analytic SQL Server Host Name
Analytic Database: Organisation Analytic Database Name (Please note that Analytic Database connection credentials is required)
AllTenants: Default to True which means no tenants filter will be applied
TenantId1 to TenantId5: Tenant Guid to be provided when All tenants are set to False