Within a Power BI report you can embed a paginated report. Values can be passed to the paginated report to populate parameters. The paginated report can be exported by a report consumer.

If you prefer a blog post https://hatfullofdata.blog/powerbie...

Table of Contents
00:00 Introduction
00:11 View Paginated Report
00:56 Switch over to POwer BI Report
01:11 Show Parameter Measures
01:44 Insert Paginated Report Visual
02:12 Add Measures to Paginated Report
03:44 Apply a Filter to the report
04:05 Enable Auto Filter
04:38 Additional Options
06:34 Export Paginated Report from published report