Power BI Q&A with SSAS Live connection

[jcichansky18]

I have SSAS Live (Tabular) model connected to Power BI, running on SQL AS 2022.

When I enable Q&A in PBI Desktop, it works as expected. As soon as I deploy to PBI Service, it does not. Cube is connected via standard gateway (updated to latest version), workspace running on PRO or Embedded workspace.

UPN enabled to translate PBI account to SQL user with admin permissions on SQL AS.

Don’t you have an idea where could be a problem?

[v-xianjtan-msft]

Hi @jcichansky18 

I would like to confirm one thing with you, are you unable to enable Q&A visual or after enabling it Q&A visual is not working properly?
Could you please provide a screenshot of your Q&A visual on Power BI Service? Take care to protect the privacy of the data in your screenshot.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcichansky18]

Thanks for your interest. I enable Q&A, open the report (in the workspace) and get message 'Preparing Q&A', later messages like 'we didn't understand your question' or 'we weren't able to load suggestions right now'. Q&A works locally in Power BI Desktop (with the same data source as described) or with import mode deployed to the workspace.

[v-xianjtan-msft]

Hi @jcichansky18 

This issue has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xianjtan-msft]

Hi @jcichansky18 

For your privacy and security, the forum does not recommend uploading information such as logs or account numbers. I'll be communicating further with PG about this on my end and will come back with an update if there's any progress. Thanks for your cooperation!

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcichansky18]

I've sent you tenant id & db name into private message. is that ok? regarding logs - where from do you need them? PBI Desktop or Gateway? thanks

[AnkitKukreja]

Hi! @jcichansky18 

If you are referring to live connection then please go through this doc as it has certain limitations. 
https://learn.microsoft.com/en-us/power-bi/create-reports/service-q-and-a-direct-query

[collinq]

Hey @jcichansky18 ,

Look at this link:  Q&A for Power BI business users - Power BI | Microsoft Learn

Particularly - make sure it is turned on and make sure it is allowed in that workspace

[jcichansky18]

I'm not really sure, that it helped really, but thanks anyway