Forum Discussion
Solved
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 mor...
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
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
Hello,
Yes that is a great suggestion that I sometimes use.
Michael
