Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Effrette
Regular Visitor

Enhanced Refresh with PPU

Hello,

 

I have a Power BI dataset set up with Incremental Refresh.

In some cases, the user would like to trigger a full refresh for all partitions (with a single click, without using SSMS).

In the Enhanced Refresh documentation, I see this requires a Premium capacity. Is Premium-per-User considered Premium capacity for this purpose?

If not, are there any other suggestions to create an automation of a refresh that refreshes al the partitions?

 

Thanks!

1 REPLY 1
pmreis
Resolver IV
Resolver IV

Hi @Effrette 

 

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.

 


Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors