Data masking security control

[JUNPEI]

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 sales?

[Anonymous · Accepted solution]

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]

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]

Hi @JUNPEI ,

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