Forum Discussion

rnoyce's avatar
rnoyce
Frequent Visitor
8 years ago

Q&A does not appear in published app

I've recently upgraded from SQL Server 2014 to 2016, including SSAS 2016 Tabular cubes.  I am now able to use the Q&A functionality within my workspace, as well as App workspaces, having set the dataset to allow this:

 

 

As well as setting the dashboard to display the Q&A section:

 

However, when I publish the App and open the dashboard, there is no Q&A section displayed.  As previously mentioned, it works in the App workspace, so I know it's not an issue with the tabular cube, or the fact it's direct query, or permissions.  Does anyone have a similar issue or solution?  Thanks

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi rnoyce,

     

    It seems like current multidimensional model still not support Q&A features.

     

    For detailed information, I'd like to suggest take a look at below below link:

    Enable Q&A for live connections

     

    Considerations and troubleshooting

    • Initially the feature is only available for SQL Server 2016 Analysis Services Tabular data sources. The feature is optimized to work with tabular data. Some functionality is available for multi-dimensional data sources, but the full Q&A experience is not yet supported for multi-dimensional. Additional data sources supported by the on-premises data gateway will be rolled out over time.
    • Full support for row level security defined in SQL Server Analysis Services is not available initially in the public preview. While asking questions in Q&A, the “auto-complete” of questions while typing can show string values a user does not have access to. However, RLS defined in the model is respected for report and chart visuals so no underlying numerical data can be exposed. Options to control this behavior will be released in coming updates.
    • Live connections are only supported with the on-premises data gateway. As a result, this cannot be used with the personal gateway.

     

    Regards,

    Xiaoxin Sheng

    • rnoyce's avatar
      rnoyce
      Frequent Visitor
      8 years ago

      Anonymous Thanks for the reply.  That is the point though, I am using a tabular data source and have got it working.  The issue is that it does not work in a published app, only in an app workspace.  So to me it appears to be an issue with published apps and not the data source

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I am experiencing this also

         

        I have  Q&A Working in the App Space but not in the Published version of the app  - The Q&A  Dialog appears in the Published app with some of the Columns and Measures  but it is not Functional  nothing you type or select returns a result.

         

        Any update or guidance on this?