Forum Discussion
mikebi
Helper III
Helper IIIgood 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
mikebiHelper III
Helper IIIHello,
Yes that is a great suggestion that I sometimes use.
Michael