odbc error

[Anonymous]

my pbix connecting to sql server  using odbc

its slow and getting error:  

Data source error ODBC error 08001 microsoft sql server native client 11.0 unable to complete login process due to delay in opening server connection details

usually hangs  amnd i have to end task!

sometime says working on it for ever !   

[v-alq-msft]

Hi, @Anonymous 

You may have to download the ODBC driver you need from Microsoft or from a third party.

You may also have to look up the required connection info that you have to provide. This third-party site - The Connection Strings Reference - contains sample connection strings and more info about data providers and the connection info they require.

For further information, please refer to the following document.

Connect to an ODBC Data Source (SQL Server Import and Export Wizard) 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.