Forum Discussion

SELECTDBA's avatar
SELECTDBA
Advocate I
6 years ago

SSAS Analysis source through blank query in a Dataflow

Hello all,   We're having difficulities adding an on-prem SSAS analysis service connection through a blank query on a Dataflow.  I've added the correct Power Query:   let Source = AnalysisSe...
Dataflow
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi SELECTDBA ,

 

Based on this document, 

The following list shows which connectors you can currently use by copying and pasting the M query into a blank query:

  • Azure analysis Services
  • Adobe Analytics
  • ODBC
  • OLE DB
  • Folder
  • SharePoint Online folder
  • SharePoint folder
  • Hadoop HDFS
  • Azure HDInsight (HDFS)
  • Hadoop file HDFS
  • Informix (beta)

 

It seems the On-Premises SSAS does not supported to used with Blank query in Dataflow.

 

We also tried to connect with a AS query in Dataflow with a gateway, but we get a InvalidDatasourceTypeForSkipTestConnectionError 

 


Best regards,

 

SELECTDBA's avatar
SELECTDBA
Advocate I
6 years ago

v-lid-msft thanks for the response and the link.  I can't help but think how big of a mistake this is on Microsoft's part - I wouldn't assume they would have an oversight this big, so maybe there is a reason?  Anyway, what do you think about a OLE DB connection to SSAS?  I tried that, but I was getting a different error.  I wasn't sure if anyone had success there.  Thanks.