Power BI Copilot Row Level Security: Security Test
I explored how Row Level Security (RLS) interacts with Copilot in Power BI and Microsoft Fabric—answering a common question about whether Copilot can bypass RLS restrictions. This walkthrough demonstrates practical steps for adding users, configuring permissions, and validating that security boundaries remain intact, even with AI-powered features. Organizations often worry that AI assistants like Copilot might expose data beyond intended roles. I addressed this by testing both admin and viewer experiences in a real Fabric workspace, focusing on what Copilot can summarize and display for each user. In this video: - I added a new user to my Merit Workspace with viewer-only permissions, showing the setup process. - I configured Row Level Security and explained how it applies to different users. - I tested Copilot interactions as both an admin and a restricted user, highlighting what each can access. - I examined whether Copilot respects RLS when summarizing or displaying data. - I demonstrated the classic RLS visual experience for a restricted user. - I verified that Copilot does not reveal unauthorized data categories. - I showed how RLS and Copilot work together in real Power BI scenarios.
Securing Data using Sensitivity Labels in Power BI
Data protection is very important in today's data-driven environment. To achieve this, organizations must apply specific policies and restrictions to maintain data integrity and confidentiality. In Power BI, we have data protection policies like sensitivity labels which allow organizations to classify and secure data in alignment with their company policies.These labels ensure that data is appropriately governed, controlled, and handled with care throughout its lifecycle. In this blog we will discuss on how Power BI’s data protection policies, like sensitivity labels, can help organizations meet their security needs while enabling efficient and responsible data collaborationPower BI Security: A practical guide to RLS, OLS and Masking
Row-Level Security (RLS) is great, but it cannot hide sensitive columns completely. When you try to use Object-Level Security (OLS) instead, your charts often crash. This post solves that problem. Learn how to implement a "Defence in Depth" strategy and discover the Field Parameter trick that allows you to hide columns dynamically while keeping your dashboard error-free.Data Governance in Microsoft Fabric: Trust, Visibility, and Control
Building a data-driven culture requires more than just modern tools—it requires trust. This article explores the three pillars of Fabric governance: Endorsement, Metadata Scanning, and Data Lineage, helping you turn data chaos into a managed, transparent environment.Developing an Azerbaijan Shape Map
A shape map is a powerful visualization tool that allows users to represent geographical data with customized regions. However, not every country’s shape is readily available in Power BI. By developing a custom Azerbaijan shape map, we can unlock better regional insights and enhance data-driven decision-making. In this guide, I will walk you through the process of creating an Azerbaijan Shape Map, ensuring that you can effectively map and analyze location-based data. 📥 Downloadable Materials: https://onedrive.live.com/?authkey=%21AOTKe2P4w9oBvmo&id=357FB5C8090FE1B2%2168360&cid=357FB5C8090FE1B2 I am working with a small sales dataset from multiple retail stores across various cities in Azerbaijan, including Baku, Ganja, Shaki, Sumgait, and Nakhchivan. Let's add another page to the Power BI file and name it "Map." We need to ensure that the Shape Map icon is visible in the Visualization Pane. If it is not available, we can enable it by navigating to File > Options and Settings > Preview Features and ensuring that the Shape Map Visual option is selected. Click on the Shape Map icon in the Visualization Pane, then add the TotalSales(F) measure. You'll notice that the map defaults to the USA Shape Map. Select the map, then go to the Format Pane and choose Map Settings. Click on Map Type, then select Custom Map to upload our map in TopoJSON format. First, let's create our custom map. To do this, search for an Azerbaijan Shapefile using Google Chrome. Click on the Humanitarian Data Exchange (https://data.humdata.org/dataset/cod-ab-aze) link. From there, download the following files: 📥 AZE_AdminBoundaries_TabularData.xlsx 📥 aze_adm_gadm_osm_20231002_SHP.zip Open the downloaded Excel file. You'll see that it contains three worksheets, listing the names of all Azerbaijani cities, districts, and ecoregions in both Azerbaijani and English. Now, we can upload the Excel file into Power BI, perform the necessary transformations, and apply the changes to our Power BI file. Now, open a new tab in Google Chrome and go to mapshaper.org. Click on Select, then upload the downloaded shapefile ZIP to Mapshaper.org. Click on Export to proceed with saving the transformed shapefile. Leave the three selected options as they are, then choose TopoJSON as the export format. Now, return to your Power BI file to continue with the next steps. Upload the exported TopoJSON file to the Custom Map in Power BI by selecting Browse under Map Settings. Now, add ADM1_EN from the recently uploaded Excel file to the Location field in Power BI. Now, we can add a Slicer to display the cities of Azerbaijan in English. Additionally, let's add a Card visual to show the TotalSales(F) value. The final step is to create a relationship between the Cities column in the dStores table and the corresponding column in the newly added Excel file in Power BI. Conclusion: Building a custom Azerbaijan Shape Map in Power BI allows for more precise geographical visualizations, enabling better insights into regional sales and trends. By leveraging tools like Mapshaper.org, custom TopoJSON files, and Power BI's Shape Map visual, we can create interactive and dynamic maps tailored to specific datasets. Integrating Excel data, establishing relationships between tables, and using slicers for city-level analysis further enhances the usability of the report. Mastering the creation and customization of Shape Maps is a valuable skill for any data professionallooking to improve spatial analysis and drive actionable insights. Let us know if this guide was helpful—we’d love to hear your feedback!
