No OLEDB provider for ODBC in SSMS or Visual Studio SSDT?

Eric Mamet 365 111 Reputation points
2021-04-18T19:04:44.14+00:00

I am trying to access Snowflake data through a SSAS tabular model (using an ODBC connection) but I can't find the OLE DB provider for ODBC on either SSMS (trying to add a link server or trying to fix a tabular model connection) or Visual Studio SSDT.

If I open an MS Access db, I could import data from OLEDB for ODBC...

Any idea what's wrong?
I have installed "everything I could find" already!

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,826 Reputation points
    2021-04-19T06:16:33.617+00:00

    Hi,

    Which compatibility level tabular project are you working with ?

    If you are working with 1500, you could find the ODBC/OLE DB at other table of get data windows.

    See :
    88965-image.png

    Regards,
    Lukas

    1 person found this answer helpful.
    0 comments No comments

  2. Eric Mamet (MSDN) 6 Reputation points
    2021-04-22T20:58:34.23+00:00

    Thank you, this solved the problem indeed


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.