Forum Discussion

AshGSmith's avatar
AshGSmith
New Member
9 years ago

Q&A Not Working on SSAS 2016 Dataset

I've got a dataset running on SSAS 2016 which should be compatible with Q&A from what I've read, however when I enable it I just get the error meesage: "We weren't able to load suggestions right now...
AshGSmith's avatar
AshGSmith
New Member
9 years ago

Hi, 

 

I've already done everything listed in that page, is there anything else that I need to take into consideration for this? 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi AshGSmith,

     

    I have a dataset connecting to SQL Server 2016 Analysis Services tabular model and the Q&A works fine for that dataset. However, I got the same error you mentioned above when I was using Q&A for that dataset this morning. The issue got fixed after I went to Settings, Dashboards and disabled and re-enabled "Show the search box on this dashboard" for that dashboard. Could you go and have a try to see if it could help.:smileyhappy:

     

    I did have an old 2014 dataset connected but that's been removed now as I wondered if that was causing the Q&A not to work for some reason, but I'm not closer to getting it sorted yet.

    By the way, have you tried removing the entire dataset and recreating a new dataset which only connecting to your SQL Server 2016 Analysis Services tabular model?

     

    Regards