title: Linked Server to Analysis Services
body: <p>After defining Linked Server on SQL Server 2016 (13.0.1711.0):</p>
  
  <pre><code>EXEC master.dbo.sp_addlinkedserver @server = N'CUBELINKEDSERVER', @srvproduct=N'MSOLAP', @provider=N'MSOLAP', @datasrc=N'POWER', @catalog=N'Model'
   /* For security reasons the linked server remote logins password is changed with ######## */
  EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'CUBELINKEDSERVER',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
  </code></pre>
  
  <p>and using query from <a href="http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/" rel="nofollow">http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/</a>:</p>
  
  <pre><code>SELECT *
  FROM OPENQUERY(CubeLinkedServer,
     'SELECT *
      FROM $SYSTEM.MDSCHEMA_MEASUREGROUP_DIMENSIONS') mgd
  INNER JOIN OPENQUERY(CubeLinkedServer,
     'SELECT *
      FROM $SYSTEM.MDSCHEMA_MEASUREGROUPS') mg
  ON mgd.XXX = mg.XXX
  </code></pre>
  
  <p>I get error:</p>
  
  <blockquote>
    <p>Msg 7354, Level 16, State 1, Line 1 The OLE DB provider "MSOLAP" for
    linked server "CubeLinkedServer" supplied invalid metadata for column
    "DIMENSION_PATH". The data type is not supported.</p>
  </blockquote>
  
  <p>How can I solve it?</p>