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

[Anonymous]

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

[v-jiascu-msft]

Hi Mohan,

I would suggest you go to https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices for professional support. 

Best Regards,

Dale