Q&A performance issues

[nandic]

Hi,

I have a dataset with 40 million rows.
When i try to use Q&A visual, it is either very slow (taking almost one minute to return results) or it gives pop-up message that dataset is too large for Q&A to handle.

Is there any known dataset size limitation for using Q&A visual?

Additionally, is there any AI solution that we can use to ask questions about data in our dataset?

There is AI Lens visual, but it handles much less amount of data.

Best regards,
Nemanja Andic

[nandic]

Thank you for the answers.
It seems just that the issue was on internet side when i was testing it.
When i tried it tomorrow, performance was as expected.
Closing this ticket.

Best regards,
Nemanja Andic

[v-yohua-msft]

Hi, @nandic 

Given the size of the dataset, the caching mechanism may not be able to optimize performance to the level required for an immediate response. You can check the following link:

Use Q&A with live connections in Power BI - Power BI | Microsoft Learn
For more tailored AI solutions, consider exploring SynapseML, which simplifies complex machine learning tasks. It allows the creation of machine learning models that can efficiently process and analyze large amounts of data. You can check out the following documents:

SynapseMl first model - Microsoft Fabric | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[StrategicSavvy]

hi @nandic 

the only limitation of Q&A I am aware is it is responding only in english. apart from this the performance is determined by capacity you are using. did you use service or desktop file? 

 I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: www.linkedin.com/in/lukasz-kozdron