Q&A Analysis Services Connector

[jbocachica]

Hi all, did you know that the Analysis Services Connector doesn't allow Q&A?, am I doing something wrong?

[Seth_C_Bauer · Accepted solution]

No, you aren't doing anything wrong. Straight out of the box it doesn't work for on prem, link here: (Third bullet under "Important")

https://support.powerbi.com/knowledgebase/articles/471633-sql-server-analysis-services-tabular-data-...

Here is the link for voting that the feature get added:

https://support.powerbi.com/forums/265200-power-bi/suggestions/6939209-add-q-a-capability-for-datase...

[Seth_C_Bauer · Accepted solution]

No, you aren't doing anything wrong. Straight out of the box it doesn't work for on prem, link here: (Third bullet under "Important")

https://support.powerbi.com/knowledgebase/articles/471633-sql-server-analysis-services-tabular-data-...

Here is the link for voting that the feature get added:

https://support.powerbi.com/forums/265200-power-bi/suggestions/6939209-add-q-a-capability-for-datase...

[GuyInACube · Accepted solution]

The reason for this is that Q&A currently relies on the data model being available in our back end (in the cloud).  When using the AS Connector, the Data Model resides in your environment and Q&A isn't aware of it, so it can't use it.

Definitely vote up the item on support.powerbi.com if this is important to you.