Error when trying to export large data from Power bi

Massingc1983,

Try returning the final variable:

EVALUATE
    __DS0Core

Hi Massingc1983 

Thanks for the reply from DataInsights .

You can try changing the formula to the following:

VAR __DS0FilterTable2 = 
        FILTER(
            KEEPFILTERS(VALUES('Append All'[Payment Date])),
            AND(
                MAX('Append All'[Payment Date]) >= DATE(2023, 5, 1),
                MAX('Append All'[Payment Date]) < DATE(2024, 6, 20)
            )
        )

Best Regards,
Yulia Xu

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