Organize my data in Power Query or Power BI Service? Power Bi Pro's, please help me :)

Hey Power BI Community!

I have a question regarding organizing my data, and I really don't find any source where it is explained well:

I have different data sources that all come from sharepoint, mainly excel files (I know, not the best source, we're working on it 😉 )

So let's say I have source 1, source 2 , source 3 and source 2.5 which is an appended query 2&3.

In the end I want to make different reports let's call it Strawberry Report (Source 1 & Source 3), Blueberry Report (Source 1,2 & 3) and Pinapple Report (Source 2.5). They all have to be shared with certain collegues. Also, all of them only use parts of the data of the sources (thus I could maybe make the data much smaller by Power-querying all the unneeded stuff away)

Right now, I am getting ALL the data in one pbix file, with 4 different queries.

I also have ALL my visualizations (reports) in one pbix file.
My goal is, to tidy up, make it more sorted.


Now the question:

1) Is it better practice to make a different pbix files and thus datasets for every report, so for example Strawberry report only queries Source 1&3, upload this report solely, updated daily, and share it with my collegues?

Or:

2) Get all the queries and slides in one pbix file that is updated daily, upload it as one "Fruit Salad Report", copy the "Fruit Salad Report" three times and throw all the unwanted Fruit out in Power BI Service, creating the strawberry salads etc which all are based on the same Power BI Dataset?

Or? 3) Is it better to make one pbix file which queries all, and then load this dataset into other pbix files, throw out unwanted data in "fields", visualize it and update every file individually?


Long term goal is to get all the data in a Microsoft ERP.

Hope I didn't make you hungry, thanks for your help guys! 🙂

Cheers,

Janik