Forum Discussion

kattlees's avatar
kattlees
Post 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.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hai sanjoyleo did you solved this scenario, if yes could you please share the procedure...

kattlees's avatar
kattlees
Post Patron
8 years ago

Yes, in Query Editor under source, then under advanced you can write and SQL statement to only pull in fields you want and put limits on such as dates.   Really helps limit the amount of data you can pull in.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you kattlees for your suggestion and it is perfectly working already but my issue is on Power BI Embedded could you please give me a suggestion on that.

     

    Kindly Regards,

    Geetha

  • lavanyak's avatar
    lavanyak
    Advocate I
    8 years ago

    Hi Kattlees,

     

    I have a simillar problem of restricting the number of rows while importing the data from SQL server to power bi using Import connection .

     

    I have seen the code for limiting the records from the thread and tried the same but it is showing error.I could not understand the error.

     

    Below is my code.

     

    let
    Source = Sql.Databases("ejazah-live-rds.c52bhszlapad.ap-south-1.rds.amazonaws.com"),
    EjazahLive = Source{[Name="EjazahLive"]}[Data],
    dbo_tb_SalesData = EjazahLive{[Schema="dbo",Item="tb_SalesData"]}[Data]
    FilteredRows = Table.SelectRows(dbo_tb_SalesData, each Date.Month([booking_date])=3)
    in
    FilteredRows

     

    booking_date is adatetime field in the database.

     

    Your help is much appreciated!

    Thanks

    Lavanya