Introducing Power Hub, an advanced solution designed for data analytics and business intelligence in Microsoft Dataverse. Power Hub is based on Azure SQL Database, providing robust capabilities to support real-time data synchronization, historical data analysis, AI and Machine Learning, and comprehensive reporting. Enhance your business intelligence capabilities with Power Hub's powerful features tailored for BI developers.

Key Capabilities:

• Near Real-Time Event-Based Sync: Power Hub supports near real-time event-based synchronization, including support for Power BI direct query, ensuring your data is always up to date for accurate and timely insights.
• Temporal Tables for Data History: Power Hub uses System Versioned Temporal Tables to maintain a full data history and easily access historical data over time. Learn more
• Pre-Defined Reporting Views: Utilize pre-defined reporting views such as item URLs, file & image URLs, monthly & quarterly snapshots, historical keys, foreign keys across tables, and SCD1 & SCD2 lookups to streamline your reporting processes.
• Support for Historical Reporting at All Granularities: Conduct detailed historical reporting at various granularities, including hourly, daily, weekly, and monthly intervals, for in-depth data analysis.
• Automated DB Maintenance: Benefit from automated database maintenance, including index management, compression, table structure optimization, and column data type adjustments, ensuring peak performance and reliability.
• Easy to Get Started with Historical Reporting: Quickly set up historical reporting with snapshots, trendlines, and audit capabilities, saving time and effort on initial development tasks.
• Support for Multiple Dataverse Environments: Manage and synchronize data across multiple Dataverse environments, providing flexibility and scalability for your BI projects.

General Features:

• Selective Sync on solutions, tables, and columns
• Dynamic schema synchronization in case of source changes
• Secure built-in access and user management
• Self-Service DB Firewall Rules for increased security and flexibility
• Check your solution's health and consumption with Azure metrics and overview
• Easy access and use of historical data for reporting and analysis
• Support for Microsoft Entra ID users and groups
• Installed on your own tenant with 100% data ownership and easy deployment
• Product support from a dedicated support team ensures a smooth experience