title: Advanced Partitions Management in Power BI
body: <p>My scenario is:
  I have 3 Dataflows:</p>
  <ul>
  <li>Recent Data (from SQL Server. Refreshes 8 times a day)</li>
  <li>Historical Data (does not refresh, just once initially)</li>
  <li>Sharepoint Excel file Data</li>
  </ul>
  <p>In my Dataset, I want to have a single Fact table that &quot;union all&quot; all 3 sources.</p>
  <p>Instead of Append transformation, I want to create 3 custom Partition (well explained here: <a href="https://www.youtube.com/watch?v=6CRqdsLjHNA&amp;t=127s" rel="nofollow noreferrer">https://www.youtube.com/watch?v=6CRqdsLjHNA&amp;t=127s</a>).</p>
  <p>I want to somehow tell the schedule refresh to only process the Recent Data and Excel Data partitions only.</p>
  <p>The reasoning is - if I do Append, then the dataset will each time process the Historical Data again and again.</p>
  <p>Now 2 questions:</p>
  <ul>
  <li>How do I tell the scheduled refresh to only process two of 3 partitions? (I can do it manually via XMLA endpoint, but I need it scheduled)</li>
  <li>What if I change something in my report (like visuals) - how do I deploy the changes without needing to recreate the partitions?</li>
  </ul>