Better report performance with millions of records

[filiparibeiro]

Hello.

I'm creating an incidents report where daily input files have each thousands of rows. To better my pbi report performance would you recommend resorting to dataflows or an sql database? Or something else?

Thanks in advance