I'm struggling to load a query and don't know what I can do.The data is from Dataverse and the largest table has 30000 rows.

When I load it it's saying there's 80000+ rows. There's not this amount in each Dataverse table but there's three merge query steps so might this be the cause of the row count?

I've tried deleting unused columns - should I be doing this as early as possible in the applied steps?

As the data will be filtered by project in report view I have considered maybe duplicating the query for each project and trying that instead of loading the entire data. Is this a viable option?

Is there's anything else I can do?

Thanks