Issue with new custom MDX feature RRS feed

  • Question

  • In the september update of PQ, you can provide a custom query in MDX when importing data from Analysis Services. So I quickly copied an existing query that works and tried it. The query produces 5 columns and 161 rows, and I can see the result in the preview. So I just hit the "Load to" button and got a popup msg telling me that "data cannot be retrieved from the server". Nothing loads, neither to the spreadsheet nor to the Data model.

    At this stage the query code has only one line. 

        Source = AnalysisServices.Database("sqlssas", "OLAP7", [Query=" SELECT ...blabla...])

    But if I add any statement to the query, even one that has no effect like a filter statement excluding a non existing value, the query loads fine. Isn't this behavior unexpected ? If you have a nice query ready to be reused, you may not need to add anything else to it.

    Friday, September 18, 2015 5:17 PM