Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 slow).
I import all my data from a SQL Database, where I have a query which says: take all the data from now till 12 months ago. Works perfect.
But when I refresh my data next week, the SQL statement still works fine, but the data from 12 months ago + 1 week is still in my imported data list. Is there a way to automatically delete the data from 12 months / + 1 week (So for instance the data from 30-10-2016 till 5-11-2016)
Kind regards
Solved! Go to Solution.
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.
#"Filtered Rows" = Table.SelectRows(dbo_DimDate, each Date.IsInPreviousNMonths([FullDateAlternateKey], 12)) in #"Filtered Rows"
Regards
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |