Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SSAS - Power Query - Load Sql Server tables giving OLE DB ODBC Error

Hello All,

Recently i have configured Sql Server 2017.

I am trying to create a cube by loading sql server tables which is on other machine.

Im able to connect it through powerbi and load.

But when i try to load it in SSAS using power query and tried to save it, it giving me error as

 

 

 

I have manually installed msodbcsql_17.2.0.1_x64 and msoledbsql_18.1.0.0_x64  these files and restared the system, and then again started the sql server and analysis services and db.

 

When i tried to load the tables again from ssas power query it giving me the same error.

 

Can any one please help.

 

Thanks You

Mohan V