Forum Discussion

DanielleJvR's avatar
DanielleJvR
New Member
1 year ago
Solved

How to query data directly from on-premises SQL Server using Microsoft Fabric

Hi there,   I have a use case where certain client data is too sensitive and they are trying to avoid sensitive data being stored anywhere else other than on their on-premises SQL Server. The clien...
Dataflow
  • SudhavaniKolla3's avatar
    SudhavaniKolla3
    1 year ago

    Hi,

    so as per my understanding, i am gving this answer and also i replicated the scenarion on my local PBI desktop.

    so you are pushing final table to lakehouse after applying tansfermations in datadlow and creating semantic model on top of the final tbale in lakehouse and trying to create PBI reports.

    instead of creating semantic model on top of final tables in lakehouse, just open PBI desktop and goto Onelake data hub and select lakehouse as source and select required tables from required lakehouse and same way select from SQL server(select required table/write query), so that the sematic model will create in DQ mode insted of live(which is almost similar to live mode only, but it allows querying from SQL serverb data as well)

    please refer my images for your reference.

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi DanielleJvR ,

Here are some of my personal thoughts on your question:

 

1. Dynamic Data Masking (DDM).

This feature allows you to mask sensitive data in your Fabric Warehouse and Lakehouse SQL Endpoints. DDM ensures that sensitive information is not exposed to unauthorized users, which can help you comply with data privacy regulations without altering your core data structure.      

You can look at this document below: 

Announcing: Dynamic Data Masking for Fabric Warehouse and Lakehouse SQL Endpoint | Microsoft Fabric Blog | Microsoft Fabric

 

2. Data Loss Prevention (DLP) Policies.

Microsoft Purview's DLP policies can automatically detect sensitive information as it is uploaded into lakehouses and take remediation actions. This helps in adhering to regulations like GDPR and HIPAA.

Here is the document you can read:

Announcement: Microsoft Purview Data Loss Prevention policies have been extended to Fabric lakehouses | Microsoft Fabric Blog | Microsoft Fabric

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.