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.


Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JUNPEI ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JUNPEI ,

    Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.