Forum Discussion

JUNPEI's avatar
JUNPEI
Frequent Visitor
2 years ago
Solved

Data masking security control

Let's say we have fact table which has sales for all country, (e.g US, China).  How can we implement a security control so that China users can only see the sales for China, US users can see US sale...
data warehouse
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JUNPEI ,

Thanks for using Fabric Community.
Yes, it is absolutely possible to implement security controls in MS Fabric to restrict data access based on user location (e.g., China or US) for your sales fact table. Here are two methods you can achieve this:
1. Row Level Security: Row-level security in Fabric data warehousing - Microsoft Fabric | Microsoft Learn
2. Data Masking: Dynamic data masking in Synapse Data Warehouse - Microsoft Fabric | Microsoft Learn

Hope this is helpful. Please do let me know incase of further queries.