Forum Discussion

nandic's avatar
nandic
Resident Rockstar
2 years ago

Q&A performance issues

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 f...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.