Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Error al actualizar los datos por API REDCAP

Buenas Tardes:

 

Tengo un tablero que se conecta a una API de redcap, hace unos días dejo de actualizar y genera un error, si lo actualizo por power bi desktop si actualiza sin problema.

 

agradezco su ayuda 

 

Error del origen de datos: DataSource.Error: <ccon>The underlying connection was closed: An unexpected error occurred on a send.. https://redcap.fcv.org/api/. </ccon>. The exception was raised by the IDbCommand interface. Table: datos_seguimiento.
URI de clúster: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Identificador de actividad: e1334c4b-3032-4192-aa66-02007330a64c
Identificador de la solicitud: 1f29ada7-933b-0358-d7ac-bd26d23a5edb
Hora: 2023-03-09 20:05:18Z

Status: Investigating
Comments
Anonymous
Not applicable

Hi @Andrea_Fuentes ,

 

Check transport layer security (TLS) 1.0 and 1.1 for Power BI. Upgrade the TLS version of your Power BI application to TLS 1.2 before then. 

 

Solution: Adding followung code  

System.Net.ServicePointManager .SecurityProtocol = SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; 

 

Follow below post suggested by microsoft support team:

https://azure.microsoft.com/en-in/updates/power-bi-support-for-transportlayer-security/

 

For original post:

The underlying connection was closed: An unexpecte... - Microsoft Power BI Community

 

Best regards.
Community Support Team_ Caitlyn