Enhanced Refresh with PPU

Hi Anonymous 

1) Yes, Premium per User (PPU) is considered a Premium capacity for the purpose of Enhanced Refresh in Power BI

2) You can modify the partition definitions temporarily to change the scope of data that is refreshed, and then revert the partitions back to their original definitions after the refresh. Something along the following lines:

1. Backup Your Work:

   • Before making any changes, ensure you have backups of your work, including the Power BI file and any server configurations.

2. Access the Model:

   • Open SQL Server Management Studio (SSMS), Tabular Editor, or a similar tool that allows you to manage Analysis Services models.

3. Modify Partitions:

   • Navigate to the partitions for the table(s) in question within your model.
   • Temporarily modify the partition definitions to include all data in the refresh scope and exclude archived data.

4. Trigger a Full Refresh:

   • Trigger a full refresh of the data model, either manually or via automation as per your setup.

5. Revert Partitions:

   • After the refresh completes, revert the partition definitions back to their original state to include the archived data.

6. Republish the Model:

   • Publish the updated model back to Power BI or your Analysis Services server.

7. Verify the Data:

   • Verify that the data in Power BI reflects the updated data and that all partitions are functioning as expected.