topic Re: Data to Excel Reporting in Developer

Data to Excel Reporting

bhalicki — Thu, 06 Nov 2025 21:20:37 GMT

Hi guys,

I have a client who uses PowerBi for data extracts. A lot of the features they are asking for are getting a bit out of hand and no longer supported by the standard table or matrix visuals. Reports also have quite a number of slicers (10 or more, with complex scenarios which aren't just a case of filtering a row in a table by a value).

Is there a better tool that is more suited to data extracts?

Kind regards,

Ben.

Re: Data to Excel Reporting

lbendlin — Thu, 06 Nov 2025 23:54:16 GMT

Depends on what the data source is and what extract features that data source offers natively.

Re: Data to Excel Reporting

bhalicki — Thu, 06 Nov 2025 23:58:28 GMT

Microsoft ecosystem (Fabric, MSSQL).

Re: Data to Excel Reporting

lbendlin — Fri, 07 Nov 2025 00:05:51 GMT

Directly connect from Excel to your data sources. Take Power BI out of the tool chain.

Re: Data to Excel Reporting

bhalicki — Fri, 07 Nov 2025 00:10:48 GMT

Thanks @lbendlin , users still need the ability to select/filter the data they want before the export is generated. I was hoping there might be a tool that produces a nice custom extract, rather than going straight to Excel. I would say paginated reports, but that tool is just nasty.

Re: Data to Excel Reporting

v-sshirivolu — Sat, 08 Nov 2025 07:28:28 GMT

Hi @bhalicki ,

Thanks for sharing the details, this comes up often as reports get larger and users need filtered Excel exports.

The most stable way to handle this is to use Analyze in Excel, which opens your Power BI dataset directly in Excel as a live PivotTable. It keeps all active slicers, filters, and hierarchies, while also respecting row-level security.

You can launch it from the Power BI Service (More options... then - Analyze in Excel) or add the button directly to your report for convenience.

If you want to offer advanced filtering (dynamic date ranges, multi-select, etc.), use a disconnected parameter table with dynamic M query parameters. This lets the report refresh or export exactly what the user selects without breaking the model.

Official Microsoft documentation:
Export data from a Power BI visualization
Create Excel workbooks with refreshable Power BI data
Dynamic M query parameters in Power BI Desktop
Create Excel workbooks with refreshable Power BI data

Best regards,
Sreeteja

Re: Data to Excel Reporting

v-sshirivolu — Mon, 17 Nov 2025 08:54:22 GMT

Hi @bhalicki ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Re: Data to Excel Reporting

v-sshirivolu — Mon, 24 Nov 2025 06:41:21 GMT

Hi @bhalicki ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you