how can i combine multiple reports into one report

[Anonymous]

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

[Greg_Deckler]

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

[Anonymous]

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

[R1k91]

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...