Error al conectar al sqlexpress

[ibarrau · Accepted solution]

Hola joseenrique. Para poder ayudarte vamos a necesitar que detalles más tu problema. Puedes inspirarte en como contarnos lo que sucede como explica este artículo: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...

Conociendo más detalles como por ejemplo de donde estas conectado a datos (desktop, dataflow, semantic model en power bi service), si es onpremise o cloud, cual es el error que se ve reflejado, etc. Con eso y todo lo que creas que suma podrías darte ideas, alternativas o soluciones.

Saludos

[v-echaithra]

Hi @joseenrique ,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[v-echaithra]

Hi @joseenrique ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @joseenrique ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra · Accepted solution]

Hi @joseenrique ,

Thank you for reaching out to Microsoft Community.

If you're encountering an error connecting Power BI to SQL Server Express, the issue could be from a number of areas including network settings, authentication, or SQL Server configuration.

Here are some possible solutions:

1) Check the Server Name - Ensure you're using the correct format, such as ServerName\SQLEXPRESS or localhost\SQLEXPRESS
2) Ensure SQL Server is Running - Open SQL Server Configuration Manager and confirm that the SQLExpress instance is active.
3) Enable TCP/IP Protocol – In SQL Server Configuration Manager, go to SQL Server Network Configuration > Protocols for SQLEXPRESS and enable TCP/IP
4) If using SQL Server authentication, verify that the credentials are correct.
5) Make sure SQL Server is allowed through your firewall.
6) If you see an SSL-related issue, then check whether the certification chain is trusted.
7) If connecting remotely, ensure SQL Server is configured to allow remote connections.

Try this troubleshooting options, If your issue did not get resolved, please provide a detailed error message, that will help pinpoint the root cause.

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Regards,
Chaithra.

[ibarrau · Accepted solution]

Hola joseenrique. Para poder ayudarte vamos a necesitar que detalles más tu problema. Puedes inspirarte en como contarnos lo que sucede como explica este artículo: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...

Conociendo más detalles como por ejemplo de donde estas conectado a datos (desktop, dataflow, semantic model en power bi service), si es onpremise o cloud, cual es el error que se ve reflejado, etc. Con eso y todo lo que creas que suma podrías darte ideas, alternativas o soluciones.

Saludos