Row-Level Security (RLS)
Row-Level Security (RLS) Row-Level Security (RLS) is a security feature in SQL Server and other relational databases that enables the restriction of access to data at the individual row level…..
Tag: Row-Level Security
Security in Azure SQL (Firewalls, AD Auth)
Comprehensive Guide to Security in Azure SQL: Firewalls and Azure Active Directory Authentication Table of Contents 1. Introduction Importance of Security in Azure SQL In today’s digital landscape, securing databases….
Diagnosing broken Entity Permissions
Entity permissions in Power Pages (formerly known as PowerApps Portals) are a critical part of managing access control to various records, ensuring that users can only interact with the data….
Power BI tile integration
Power BI tile integration is a powerful way to embed rich, interactive visualizations directly into your web applications or Power Pages (formerly Power Apps Portals). By embedding Power BI tiles….
Embedding Power BI into Portals
Power BI is one of the most powerful business intelligence tools offered by Microsoft, allowing users to visualize and share insights from their data. As organizations become more data-driven, the….
Drillthrough and Cross Filtering in Dynamics Reports
Introduction Modern business intelligence is not just about displaying static data—it’s about enabling users to explore, interact with, and drill into data for deeper understanding. In the Dynamics 365 ecosystem,….
Advanced Filtering Techniques
Introduction In today’s data-driven world, extracting meaningful insights from massive datasets is more than just connecting to a source—it’s about filtering data efficiently and precisely. Whether you’re a business analyst….
Embedding Reports with RLS in D365
Introduction As data becomes increasingly central to decision-making, embedding analytics directly within business applications like Microsoft Dynamics 365 (D365) is becoming a must-have for organizations. Embedded reports not only improve….
Multi-Table Lookups and Design Patterns
Multi-Table Lookups — At a Glance Multi-table lookups occur when a field (or lookup) in a table can reference data in more than one other table. They’re used to model….
Power BI Row-level Security with Dataverse
Power BI Row-Level Security (RLS) is a powerful feature that allows users to define security roles and rules to restrict access to specific data rows based on the user’s identity…..