good resources for data prepping in SQL before Power BI

Hello,

When working on a large project I feel that there should be some data modelling ahead of Power Query in SQL.

As an example sometimes creating calculated fields, joins,  etc is easier and more efficient in SQL.

I also feel that data cam be filtered in SQL before PowerBI to reduce data load times.  As an example, let's say I only want to load 4 years of data.  It could be more efficient to create a view of 4 years of data vs bringing in all the data into Power Query and then filtereing.

Are there any resources on data prepping for PowerBI using SQL Server?

Thank You,

Michael