Forum Discussion

Santhoshyeravel's avatar
Santhoshyeravel
Frequent Visitor
3 years ago

Distinct Count in Aggregation table (Huge data table)

Hi All,   I have table with huge data of records around 700 million used the aggregation table for some KPI which are using the  sum aggregation functions but unable to get the distinct count with ...
Need Help
Show and Tell
Tips and Tricks
Santhoshyeravel's avatar
Santhoshyeravel
Frequent Visitor
3 years ago

hi Anonymous 

thanks for the reply 

Able to get the distinct count but using the direct query it has taking more time and visual is getting time out error(255 sec) .Is any other way to slove this issue ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Santhoshyeravel ,

    Please provide the screenshot with the error.

    I have also found a helpful document, please refer to it to see if it helps you

    Using DirectQuery in Power BI - Power BI | Microsoft Learn

     

    Best Regards

    Community Support Team _ Polly

     

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