Microsoft SQL OLAP

Hi,

is there any way how to connect to MS sql OLAP service with metabase?

I think the only way would be to create a linked server in a SQL Database. You’d then need to either use MDX (not sure if Metabase would accept it), or create views on the SQL datase to query the MDX.
Take a look at this:
https://www.sqlshack.com/linking-relational-databases-with-olap-cube/

1 Like