topic Re: how can i combine multiple reports into one report in Report Server

how can i combine multiple reports into one report

Anonymous — Tue, 10 Jan 2023 14:27:17 GMT

i want to combine multiple reports into one how can i do that? with power bi or SQL?

Re: how can i combine multiple reports into one report

Greg_Deckler — Tue, 10 Jan 2023 14:47:35 GMT

Anonymous Need more information. You can do this with a Dashboard or App. Or are you talking about data models?

Re: how can i combine multiple reports into one report

Anonymous — Tue, 17 Jan 2023 19:44:19 GMT

hey! im talking about 4 different excel files combine them into one report?

Re: how can i combine multiple reports into one report

R1k91 — Wed, 18 Jan 2023 16:51:12 GMT

it depends on which tools you have...

Since you are posting in "Report Server" forum I assume you have a SQL Server On-Prem infrastructure so you can probably build SSIS to load the excel files into a DWH/DataMart database and then load them into a Power BI model to build your reports.

you could bypass DWH/DataMart and build starschema directly in POwer BI manipulating data accordingly in Power Query.

it depends...