User interacting queries

For my PBI desktop app I have done following:
I have a database, that has tons of gigabytes data. I managed to use slicer, to filter the relevant data I need and managed to create graph pages that I needed. It is a big laggy for desktop app, it takes roughly half a minute to load up all my data after messing with slicers, and my PC has actualy quite good performance, above 2022 average. All seems to working relevantly smootly in desktop app, but now I like to move my app to PBI web server.

For server, this same app I created is too heavy. Since I am using slicer to filter out of data from database, it wont run well with server side. Sadly my database schematics is made in a way, that its very painful to manually filter out the data that the user needs. I have to change the concept how I load data into my power BI app.

Now i heard that there is way to use queries, to load up only relevant data I need. I would like to create app, in which user can configure what data to load from the database, instead of loading huge amount of data and trying to slice it by user choices in slicers.

Any idea how to create queries, that will interact with something, that user types or selects in power bi? Selections could be done with example drop down menus, buttons or even by using slicers(that do not initially load up whole data base).
Is this even possible in power bi?