PowerTable sheets in Fabric Plan, is a no-code data app for managing dimensions, master and reference data, and business entities, stored and governed in Fabric SQL tables. Here's a roundup of the latest updates, covering security, automation, data entry, tracking and everyday usability. 1. Security - Layered Up! Protect sensitive data with security that builds […]
If you need to add new members - products, cost centers, customers, territories - during an active planning cycle, you might reach for Insert Rows directly in the Planning sheet - but that's not what the feature is designed for. This post explains the difference between what Insert Rows is designed for and what PowerTable […]
Microsoft Fabric aims to unify everything from data integration and engineering to batch and real-time analytics under a single, cohesive SaaS data platform. Beyond analytics, the platform has also branched out into transactional use cases with the likes of SQL databases or Activator event detections. But that still leaves many operational scenarios that require bulk […]
Microsoft Fabric offers three specialized database engines for different workloads: SQL Database for transactional processing with ACID guarantees, Data Warehouse for analytical workloads with T-SQL compatibility, and Lakehouse for flexible data lake scenarios with read-only SQL access. Learn how to choose the right engine for PowerTable applications based on your specific requirements for consistency, performance, and governance.
We've spent decades getting the relationship between transactional systems and analytics backward. In the early days of enterprise computing, organizations ran analytics directly on their transactional systems. This created performance nightmares as analytical queries locked up databases that were trying to process orders and run the business. The industry responded by splitting systems: transactional workloads […]
