Issues accessing data

Dear Jotform Team,

I am experiencing issues connecting the following Excel sheets to the Power BI cloud service:

• https://www.jotform.com/excel/253448751393061
• https://www.jotform.com/excel/221386073561051

Previously, the connection worked without any problems, but it has now stopped working and displays this error:

**************************************************

Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259" }},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The request was aborted: Could not create SSL/TLS secure channel." }},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259" }},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://www.jotform.com/excel/253448751393061" }},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error" }}],"exceptionCulprit":1 }}}

URI de clúster: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net

Identificador de actividad: ef9142bc-69b6-4277-b02c-1f7f1e6d5632

Identificador de la solicitud: 16da8ef2-3501-1ede-59e3-c553c9012672

Hora: 2025-12-12 05:39:07Z

**************************************************

**************************************************

Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259" }},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The request was aborted: Could not create SSL/TLS secure channel." }},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259" }},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://www.jotform.com/excel/221386073561051" }},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error" }}],"exceptionCulprit":1 }}}

URI de clúster: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net

Identificador de actividad: ef9142bc-69b6-4277-b02c-1f7f1e6d5632

Identificador de la solicitud: 4c449df6-5dac-24ed-493f-3917da900e07

Hora: 2025-12-11 17:30:02Z

**************************************************

Could you please verify if there is any issue with your SSL/TLS certificate?

Additionally, I would appreciate guidance on how to access the information from this Excel sheet through an API as an alternative solution.

Thank you for your assistance.

Hi Meza_Damazo,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Regarding your issue with connecting Jotform Excel sheets to Power BI and the SSL/TLS secure channel error, Jotform uses a secure 256-bit SSL connection with industry-standard SHA256 certificates to protect all forms and data. There are no known issues with our SSL/TLS certificates that would cause this error on our end.

For accessing your Excel report data as an alternative, you can use the Jotform API. To do this, you need to generate an API key from your Jotform account under the API section. The API allows you to authenticate and retrieve form data programmatically, which can then be integrated with other services like Power BI.

Here’s how to generate your Jotform API key:

1. Go to your Account API page.
2. Select Create New Key.
3. Name your API key and set the permissions (read-only or full access) as needed.

Once you have the API key, you can use the Jotform API documentation to learn how to access your form submission data in JSON format, which can be used in Power BI or other tools.

Let me know if you need further guidance on using the API or troubleshooting the connection issue.

Give it a try and let us know how it goes.