Forum Discussion

sasdfasdfsad's avatar
sasdfasdfsad
Advocate IV
3 years ago
Solved

SQL Native Client is recommended but has been deprecated?

The PowerBI documentation says to use the SNAC (SQL Server Native Client) but that has also been removed and it suggests using the newest OLE DB driver....??? Power Query SQL Server connector - Powe...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi sasdfasdfsad ,

     

    Here's my personal understanding: it means that Power BI doesn't need best/high performance for connecting to SQL Server by default, so the OLE DB driver is installed. But if you need the best performance, you need to install SQL Server Native Client before using the SQL Server connector. 

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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

sasdfasdfsad's avatar
sasdfasdfsad
Advocate IV
3 years ago

Why do they recommend using the SQL Native Client driver if it has been depreciated though?  That's the weird bit.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi sasdfasdfsad ,

 

Here's my personal understanding: it means that Power BI doesn't need best/high performance for connecting to SQL Server by default, so the OLE DB driver is installed. But if you need the best performance, you need to install SQL Server Native Client before using the SQL Server connector. 

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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