Connect SQL Server - Analysis Services

1

Hi Team

I can connect to analysis services using Microsoft SQL Server management Studio.

I tried to use SQL server connection, but cannot get it to work.
Any suggestions?

image

This link into power bi workspace.

Thanks

2

Analysis Services is a special (OLAP) type of database. It’s not a regular SQL Server database and it’s currently not supported in EasyMorph.

You can install the ODBC driver for Analysis Services and connect to it using the ODBC connector in EasyMorph, with the “Other SQL” dialect. In this case, you will be able to write custom SQL queries but that requires knowing the SQL dialect of Analysis Services (MSAS).

1 Like
3

Thanks, Dmitry