This sounds like the perfect job for a Dataflow. Not sure how familiar you are so here's the starter link:
https://learn.microsoft.com/en-us/power-query/dataflows/create-use
Keep in mind the Dataflow doesn't surface the data for you - it will read your table, transform your data, and then let you put it somewhere else. You then still must read this destination table. You can however build Dataflows directly in to Power BI if that is your reporting tool.
Dataflows are ideal for reading "whole" data and breaking it up into it's component parts i.e. you can break up the data into all of the different dimensions or slices e.g. get all of the listed statuses and put them into a status table, get all the listed users and put them into a user table etc but it all depends on your appetite and how excited you get when modelling data. Of course, if you just want to Filter and Distinct then it will do that too 😊.
If you are using Dataverse for Teams, Dataflows are available right in the Power Apps editor:
If you are using Dataverse, Dataflows are accessible from the main nav bar on the left. (If not there, choose the More option and add it):
