Forum Discussion

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

SergeiBaklan

Diamond Contributor

Jul 30, 2020

Dirk VERLIEFDEN

Power Query in Power BI Desktop and in Excel are definitely bit different, especially if compare with Excel 2016. However, ConnectionTimeout shall work in Excel. I have no my own experience, please check this post https://blog.crossjoin.co.uk/2014/09/29/advanced-options-for-loading-data-from-sql-server-with-power-query/ at the bottom and comments, it was written at pre-PowerBI Desktop time, most probably with Excel 2016 as sample.

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.

SergeiBaklan
Diamond Contributor
Jul 30, 2020
Dirk VERLIEFDEN

Sorry, I don't know
- 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
    Diamond Contributor
    Dec 22, 2020
    Dirk VERLIEFDEN
    
    In Excel please check data source parameters for this source - credentials, encryption