2023.2 Release

Enhanced Power BI and Excel Integrations for Scaling Enterprise Analytics on Cloud Data Platforms

In the demo, Dave Mariani, Co-founder and CTO at AtScale, discusses five important enhancements to its Microsoft Analytics integration:

  • AtScale Connector for Power BI: Power BI Desktop now includes a connector enabling simple connection of a Power BI workspace to an existing AtScale model.
  • Support for both Tabular and Multidimensional Connections to Power BI: This new capability offers maximum flexibility to Power BI users with both tabular and multi-dimensional interfaces to the same AtScale model. This enables Power BI developers to use custom DAX calculations while also maintaining the structure and governance offered by a multi-dimensional model.
  • Advanced Modeling Utilities: AtScale now provides BI architects with a set of modeling utilities that simplify creation of common, but complex, model elements like time-relative measures, intelligent dimensions, and calculation groups. By leveraging native DAX and MDX connectivity, Power BI and Excel users inherit the full intelligence embedded in the AtScale model, thereby simplifying sophisticated dashboard design and analytics product development.
  • Model Object Shareability: BI architects can now easily share model objects, such as metric definitions, conformed dimensions, or time-relative calculations, across AtScale models. This simplifies BI modeling and enables Power BI and Excel dashboard designers to leverage pre-built model elements as they build the data sets in their analytics workspaces.
  • Analytics Governance Utilities: AtScale now supports data mesh and hub-and-spoke analytics design principles, empowering centralized analytics teams to enforce consistent dimensions and metrics definitions. These governed model elements can be implemented by Power BI dashboard designers or business analysts working with Excel.