Managing and Exporting High-Volume Datasets (~1M Records) in Power BI

Hi v-hashadapu , Gabry , Poojara_D12 
I just wanted to clarify few things about the actual requirement so that all of us are on same page, the things is in the Power BI report we will be have 10-15 slicers (most of them built using field parameters {numeric}, some being of date type and others) which was shared by Anonymous at the very beginning it something looks like:

So the end user plays around these filters and once done, based on that visuals on the respective page are filtered so this data (shown by the visuals) is to be exported and for these reports to be accessed by a wider audience (end users) the Power BI report is been embedded in a web application (kind of website), wherein these interactions will take place, so from that perspective we are looking for a solution (which is more end-user friendly).
So far based on the conversation we have:
1. Power Automate + Fabric Notebook + Lake house (This is one of the ways but a bit complex)
2. Analyze in Excel (doesn't work in case of Embedded reports <- no use)
3. Translytical flow (This cn be an option but since we are using embeded reports as of now as per the official documentation embeded reports isn't supported)
4. Use of DAX QUery/Bravo (external tools): These are more useful for the developers and not for end users.
And my colleague SantoshPothnak  just shared few additional points which describes few technical details (the license and the scenario) based on the context could you help in aligining how should we proceed.

I know this thread has been longer but since there's no direct way to achieve the same, we are trying out things (which takes time and note the issues).

Regards,
Sidhant.