This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
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 :
Regards,
Lukas
Thank you, this solved the problem indeed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 88%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
Thanks for posting here.
Glad to know that Lukas's suggestion helped, could you please accept it as an answer? By doing so, the other community members could find the correct solution more quickly , thanks for your support.
Hi,
Did your project work successfully?