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