When should DirectQuery be used?

Question

Accepted Answer

DirectQuery should be considered when:

    
        Data volumes are extremely large.
        Real-time reporting is required.
        Data cannot be stored inside Power BI.
        Strict compliance requirements exist.
    

    However, it may have slower performance compared to Import Mode.

When should DirectQuery be used?

Answer with Explanation