Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Connecting to Qlik Sense app SSAS cube using data load editor

I have one question about data load editor.

I need to use SSAS cube as data source for my qlik sense app.

I have tried to use Microsoft OLE DB provider for Analysis Services 12.0.

I selected one dimension and pressed "Insert script".


and when I press button "Load data" I receive the following error


Whereas there no error description can anyone tell what is the reason of error - syntax, provider not correct, or something another?

Thanks in advance.

1 Reply
Not applicable

There is some comma or semi colon or some brakets missing.

above SQL Selelct  except conncetion string comment lines