Forum Discussion

sharpedogs's avatar
sharpedogs
Advocate II
6 years ago
Solved

Hourly Updates multiple files from a folder -

I'm not sure what to do here?   1) I'm reporting against Server Utilization  2) Each Hour there are 7 CSV files dropped into a folder  3) I pull all files from the folder and merge them together ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi sharpedogs 

    You could add a step "filtered rows",

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each DateTime.Date([datetime])=DateTime.Date(DateTime.LocalNow()) and Time.Hour([datetime])<= Time.Hour(DateTime.LocalNow()) and Time.Hour([datetime])>= Time.Hour(DateTime.LocalNow())-1)

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

So, not 100% clear. Are you saying that the 7 files get replaced each hour or get added to the folder?

 

Regardless, you should be able to filter based upon the time. You could do this dynamically by using a measure that grabs the MAX timestamp in the table. Then you just use that to include everything that has an hour of that measure - 1 hour for example. Would need to better understand your data adn report though. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490