Using Qlik Sense September 2018. I have a crazy requirement to load data from an OLAP Cube. When creating the OLE DB Connection I do not see Microsoft OLE DB Provider for Analysis Services as a provider. Is this provider limited to older (or newer) Qlik Sense releases? or maybe there is another provider that can be used in its place?
I just had the same issue, and I was able to resolve this issue, by installing Client libraries for connecting to Analysis Services and OLE DB Drivers for OLE DB Driver for SQL Server, because the OLE DB Provider for SQL Server was not working for my connection. Find the links to both drivers below:
Client Libraries for Connecting to Analysis Services (Connect to SQL Cubes)