New Standard Reports
A new set of standard Power BI reports has been developed, underpinned by three new data models designed to replace the legacy model. It has been designed without the use of dataflows, opting instead for a direct connection to Dataverse using a hybrid storage mode.
Across the models, key tables such as Portfolio, Program and Project are configured in DirectQuery mode to support row-level security (RLS) by leveraging Dataverse's native security framework.
This setup also ensures that these critical tables provide live up-to-date data. The remaining tables are configured in Import mode to optimise performance and efficiency.
This architecture strikes a balance between real-time data access and performance optimisation while aligining with Altus's security standards.
Comparison between both the Data Models:
References
Installation procedure for new Standard Reports and Models (Strategy Model, Portfolio Model and Project Governance Dashboard) can be found here:
New Altus Standard Reports Installation
Details of the Model and Reports can be found here: