Solved: Q&A Analysis Services Connector

jbocachica · ‎07-01-2015

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

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co

Seth_C_Bauer · ‎07-01-2015

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...

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

GuyInACube · ‎07-01-2015

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.

Adam W. Saxton | Microsoft Employee | Azure Data / Fabric CAT
@GuyInACube | youtube.com/guyinacube