topic Re: Data masking security control in Data Warehouse

Data masking security control

JUNPEI — Wed, 05 Jun 2024 19:27:28 GMT

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?

Re: Data masking security control

Anonymous — Thu, 06 Jun 2024 05:40:22 GMT

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.

Re: Data masking security control

Anonymous — Fri, 07 Jun 2024 09:20:27 GMT

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

Re: Data masking security control

Anonymous — Fri, 07 Jun 2024 17:08:03 GMT

Hi JUNPEI ,

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