Forum Discussion

emilisalas's avatar
emilisalas
Regular Visitor
1 year ago
Solved

Networking options Fabric

Hi, we are doing a proof of concept with Fabric. We have created a Lahehouse with one database. This database is published on Internet. Is there a way to protect by IP (to connect only from IPs provi...
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi emilisalas,

     

    Thank you for reaching out to us on the Fabric Community Forum. We sincerely apologize for the inconvenience caused.

     

    Yes, in Microsoft Fabric, you can restrict access to a database by configuring IP-based firewall rules, similar to how you would in Azure Synapse Analytics. Here’s how you can achieve that:

     

    • First navigate to the Fabric portal and go to the workspace where your Lakehouse and database are located then in Microsoft Fabric, security and access controls are typically managed at the workspace or database level and check the Lakehouse settings or associated SQL Endpoint settings in your workspace.
    • If you are using a SQL Endpoint or related services, go to the Networking section in the settings and configure IP firewall rules to restrict access to specific IP ranges then add the allowed IP addresses or CIDR ranges you want to permit access from.
    • At last to further secure the Lakehouse database, consider enabling Private Link or Private Endpoints to restrict access over a private network rather than the public internet This ensures that only approved IPs within your private network can connect.


    I believe the steps provided above will help in understanding and resolving the issue. If you still encounter the problem after implementing them, please reach out to us with the relevant error details. This will assist us in investigating the issue more effectively.

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


    Thank you.