Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI - Direct Query taking too long

I have a large data set table approximately 77million records and Power BI Direct Query takes a long time or even doesn't work if I want to view small dataset using Slicers? Import Table is not an option either as the refresh time is too long. Please suggest, Thank You!

Need Help
Show and Tell

1 Reply

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi Anonymous ,

    For direct query, every time when we change the slicer, it will run refresh data from data source, querying 77million records should take long time.

    In this scenario, we can use some workaround based on your environment, for instance, we can create some view on the data source for each selection in slicer, then calculate these data at data source end, then it will not take much time to transfer result to PowerBI.

    Best Regards,

    Teige