Maxim Zelensky created a guest video for BI Elite on how to append historical data using Dataflows for Power BI reports. This uses the Service and Dataflows and is very useful to merge new rows of data with historical/past rows. I consider this an expert level tip.