Hi Sonalim ,
If a connection to the Warehouse used to work fine but starts to fail without changes in user permission, firewall policy, and network configuration, try these steps:
Check the status of the Warehouse and ensure it’s not paused.
Don’t immediately retry the failed command. Instead, wait for 5 to 10 minutes, establish a new connection, then retry the command.
In Microsoft Fabric, two types of authenticated users are supported through the SQL connection string: Azure Active Directory (Azure AD) user principals, or user identities Azure Active Directory (Azure AD) service principals.
The SQL connection string requires TCP port 1433 to be open. TCP 1433 is the standard SQL Server port number.
If you’re trying to connect to your SQL Server without a gateway, it’s important to note that unless your data source is a cloud data source like Azure SQL Database, you will likely need a Gateway for refresh. However, if your SQL Server is hosted on Azure, Power BI can connect to an Azure SQL DB without a Gateway.
Troubleshoot the Warehouse - Microsoft Fabric | Microsoft Learn
Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
Solved: Connect to MS SQL Server 2014 without gateway - Microsoft Fabric Community
Best regards.
Community Support Team_Caitlyn