Forum Discussion
Aggregating Historical Data
I have X number of previous months data with a computer name, model, serial number, last online date. January A , laptop a , 2ac , 1/17/17 B , laptop a , 5ga , 1/27/17 C , laptop b , n3f , ...
I belive you are looking for incremental refresh which is only available in Power BI Premium. See bleow link for more info
https://docs.microsoft.com/en-gb/power-bi/service-premium-incremental-refresh
I'm not having any trouble with the refresh the data is static. I'm having trouble performing the correct data operation detailed in my original post. I don't believe that the refresh affects my ability to do this:
if "computer name" exists, add column "Last date seen.1"
else add new row, set "Last date seen" = null, rename "last date seen" to "last date seen.1"
bump