Forum Discussion

Dirk VERLIEFDEN's avatar
Dirk VERLIEFDEN
Copper Contributor
Jul 30, 2020

Excel Power Query SQL timeout

Hello, Recently my company started using Azure VPN. I have a large number of Power Queries in Excel on SQL databases. Since the move to this Azure VPN I can't run the queries in Excel (v2016-32bit...
excel
power bi
Dirk VERLIEFDEN's avatar
Dirk VERLIEFDEN
Copper Contributor
Jul 30, 2020

SergeiBaklan 

Thank you for your reply.

I only get the timeout when connecting Excel query through Azure VPN, not when I'm connecting through Forticlient VPN.
Is there a setting in Excel for Azure VPN?

Regards,

Dirk.

  • Dirk VERLIEFDEN's avatar
    Dirk VERLIEFDEN
    Copper Contributor
    Dec 22, 2020

    Timeout problem has disappeared.

    However, now I can't connect due to another error:

    DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

     

    When I copy-paste the M-code from the Excel (2016) power query into Power Bi power query, there is no error!?
    Any advice?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 22, 2020

      Dirk VERLIEFDEN 

      In Excel please check data source parameters for this source - credentials, encryption

Resources