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...

sanjoyleo's avatar
sanjoyleo
Helper I
8 years ago

Hi GeetzAnju,

 

I  have seen that MS is going to implement,not sure if they implement in last 2 months as I was not following that.

But as of now there is no was to do partial import or Delta import. In my Solution I moved to Direct query as I used date filter to show the data. 

  • 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.