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

Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Then just remove second line of code and just keep:

WHERE CreatedDateTime >= DATEADD(month,-12,DATEADD(day,DATEDIFF(day,0,GETDATE()),0))

This should resolve your issue!!!

 

 

Regards

Abduvali 

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

  • Abduvali's avatar
    Abduvali
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    v-ljerr-msft,

     

    Thank you =D Will try it out sometime!!!