Forum Discussion
SSAS and SSRS Connectivity with AI Visuals like Smart Narrative Key Influencers
- 1 year ago
Hi SJain123 ,
The issue you're encountering arises because AI visuals in Power BI, such as Smart Narrative and Key Influencers, are not supported when using live connections to Azure Analysis Services (AAS) or SQL Server Analysis Services (SSAS). These visuals require access to the underlying data model for analysis, which isn't possible with live-connected external models. To enable the use of AI visuals, you can consider switching to import mode, allowing Power BI to load and analyze the data internally.Alternatively, you could use a composite model, where key data for AI visuals is imported while maintaining a live connection for the rest. Another option is to extract a relevant subset of your cube data and re-model it within Power BI as an imported table, specifically for use with AI features. These approaches can help you leverage AI visuals while continuing to work with SSAS or SSRS-based data sources.
Hi SJain123,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rohit1991 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
- v-achippa1 year ago
Community Support
Hi @SJain123,
We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
- v-achippa1 year ago
Community Support
Hi @SJain123,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa