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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

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