Need Help to conect PowerBi to SQL Fabric

[Brenner]

I'm trying to implement a Writeback using Translytical Flow. I created the database in Fabric and everything worked. But when I try to connect my report on the desktop, I'm getting an error.

DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - O nome da rede especificado não está mais disponível.)
Detalhes:
DataSourceKind=SQL
DataSourcePath=nr5qaxulexpe7lobrp4kcnmilu-77fctlevrz2uhgfjzvig2dhi2y.database.fabric.microsoft.com;TranslyticalIDB-79b67c29-f63b-4c7f-a422-0e8ccfd37170
Message=A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - O nome da rede especificado não está mais disponível.)
ErrorCode=-2146232060
Number=64
Class=20
State=0
ConnectionId=aa56ac14-547f-422c-ad1a-b20077213517

[v-karpurapud · Accepted solution]

Hi @Brenner 

Thank you for reaching out to the Microsoft Fabric Community Forum.

The problem you are experiencing when connecting Power BI Desktop to your Fabric SQL Database is due to network connectivity, not authentication or configuration. Although the initial connection on port 1433 works, the login fails because Microsoft Fabric SQL  uses a redirect mechanism requiring outbound ports in the 11000–11999 range. These ports are currently blocked by your corporate firewall or proxy, resulting in the error: “A connection was successfully established with the server, but then an error occurred during the login process (provider: TCP Provider, error: 0 – The specified network name is no longer available)”. To fix this, your network team should allow outbound traffic to *.database.fabric.microsoft.com on TCP 1433 and TCP 11000–11999, and make sure TLS 1.2+ is enabled without SSL inspection for this domain. Access to Microsoft Entra ID authentication endpoints like login.microsoftonline.com also needs to be allowed. After these network changes, you should be able to connect Power BI Desktop to your Fabric SQL Database using the server name from the Fabric portal and your organizational Microsoft account for authentication.

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.
 

[Shahid12523]

In Power BI Desktop → Get Data → SQL Server

Server:

<your-db>.<region>.database.fabric.microsoft.com

Database: your Fabric DB name (or leave blank).

Authentication type → choose Microsoft/Organizational Account (not Windows or SQL).

Sign in with your Fabric AAD account.

Ensure port 1433 is open on your network (firewall).

[Greg_Deckler]

@Brenner Check if there is a known issue, looks like there might be one: Microsoft Fabric Known Issues