Forum Discussion
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
1 Reply
- v-jiascu-msftMicrosoft Employee
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