Composite Model help

[Anonymous]

Hi Experts,

                   Need your help in getting the below requirement

i have to load the 6 months of data into power bi using sql native query with always latest current month with import mode and remaining 5 months with direct query mode.overall rolling 6 months of data i have to get with sql native query in power bi and could some one of you please let me know how to get this with sql query.

Regards,

Aneetha.

[lbendlin]

Are you planning to use aggregations?  Are you planning to use incremental refresh? Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?