good resources for data prepping in SQL before Power BI

[mikebi]

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

[v-shex-msft · Accepted solution]

HI @mikebi,

I'd like to suggest you turn on the advanced option on the data connector to use sql statement to pre-processing of the result or customize the result tables.

Import data from a database using native database query - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[mikebi]

Hello, 

Yes that is a great suggestion that I sometimes use.

Michael