Forum Discussion

kattlees's avatar
kattlees
Icon for Post Patron rankPost Patron
8 years ago
Solved

Limit import based on date

I am new to Power BI and have decided to do import vs direct query.   Is there a way to limit the records imported based on date to save time/space? Our system has 20 years of data and if we only w...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    select filter on your date column and then choose parameter as show below in below circle, and select your parameter.

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous let me know if you still need assistance.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k 

Yes, I do. If you have some time to help I would appreciate it!

 

I tried to re-create your solution for someone else on this string to pull in 1 yrs worth of data instead of the full 10 years and then filtering. Do I have my #Year in the correct spot? This is an ODBC connection to an OpenEdge software called Chempax.

 

let
    Source = Odbc.DataSource("dsn=Chempax Live", [HierarchicalNavigation=true]),
    #"Year" = Date.Year(DateTime.LocalNow())-1,
    CHEMPAX_Database = Source{[Name="CHEMPAX",Kind="Database"]}[Data],
    SQLVIEW_Schema = CHEMPAX_Database{[Name="SQLVIEW",Kind="Schema"]}[Data],
    #"BATCH-REC-HDR_View" = SQLVIEW_Schema{[Name="BATCH-REC-HDR",Kind="View"]}[Data],
    #"Filtered Rows" = Table.SelectRows(#"BATCH-REC-HDR_View", each Date.Year([#"Receipt-Date"]) >= #"Year"
    )
in
    #"Filtered Rows"