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

Thank you so much for your response sanjoyleo I am also working in the same scenario, I have two parameters such as the StartDate and EndDate and it works fine in the Power BI Desktop and Power BI Service too but my problem is it was not working properly in Power BI embedded, I have embedded my report in Asp.Net MVC application and for the parameters I have provided two listboxes for the user to select the StartDate and EndDate, and I am using javascript for specifying the filters to Power BI Service but the filter was not reflecting in the report. Do you have any idea about this please provide your suggestion.

 

Kindly Regards,

Geetha

sanjoyleo's avatar
sanjoyleo
Helper I
8 years ago

Hi,

 

I didn't work on that scenario.. so can't help much here.