Forum Discussion

miltenburger's avatar
miltenburger
Icon for Helper V rankHelper V
8 years ago
Solved

Automatically delete data from import

Hi all,   Currently i'm finishing my intership assignment. But i face 1 issue during refreshing my data. Currently I import all my data into Power Bi (I also tried DirectQuery but it is way to slo...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Abduvali,

     

    Instead of using SQL statement, you should also be able to simply use Date.IsInPreviousMonth function(M) in Advanced Editor to import data from now till 12 months ago. :smileyhappy:

        #"Filtered Rows" = Table.SelectRows(dbo_DimDate, each Date.IsInPreviousNMonths([FullDateAlternateKey], 12))
in
    #"Filtered Rows"

     

    Regards

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Should be possible in Power Query to run Date.IsInPreviousYear on your date field and filter out those that aren't