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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
bvy
Helper V
Helper V

Incremental Refresh in the Service - How to schedule/trigger the occasional FULL refresh?

Hi everyone. I was able to set up several of our Power BI reports to use an incremental refresh policy on certain large tables. Everything is Import, not Direct Query. So far it's working great and as expected. Over time though, the older data will gradually change, and we need a way to schedule or trigger a FULL refresh (i.e. all partitions) maybe once a week or so. Can someone advise how to do this? We primarily use Power Automate to trigger refreshes, but none of the tasks have that option. What's the best approach here? Thanks. 

1 ACCEPTED SOLUTION
Gabry
Super User
Super User

Hello  you can select wich partition to refresh with SSSM. Maybe also with other tabular editor or via api. Try to look at this documentation https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

 

Of course I don't know if you can do it with a PRO sub.

 

Because I read:

For models in a workspace assigned to a Premium capacity, partitions can be managed through the XMLA endpoint by using tools like SQL Server Management Studio (SSMS), the open-source Tabular Editor, scripted with Tabular Model Scripting Language (TMSL), and programmatically with the Tabular Object Model (TOM).

 

Also:

Refresh management with SQL Server Management Studio

SQL Server Management Studio (SSMS) can be used to view and manage partitions created by the application of incremental refresh policies. By using SSMS you can, for example, refresh a specific historical partition not in the incremental refresh period to perform a back-dated update without having to refresh all historical data. SSMS can also be used when bootstrapping to load historical data for large models by incrementally adding/refreshing historical partitions in batches.

 

@bvy

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

Specify the refresh type as full instead of automatic

 

cube - SSAS Tabular Model - Partition Refresh and Schedule - Stack Overflow

Gabry
Super User
Super User

Hello  you can select wich partition to refresh with SSSM. Maybe also with other tabular editor or via api. Try to look at this documentation https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

 

Of course I don't know if you can do it with a PRO sub.

 

Because I read:

For models in a workspace assigned to a Premium capacity, partitions can be managed through the XMLA endpoint by using tools like SQL Server Management Studio (SSMS), the open-source Tabular Editor, scripted with Tabular Model Scripting Language (TMSL), and programmatically with the Tabular Object Model (TOM).

 

Also:

Refresh management with SQL Server Management Studio

SQL Server Management Studio (SSMS) can be used to view and manage partitions created by the application of incremental refresh policies. By using SSMS you can, for example, refresh a specific historical partition not in the incremental refresh period to perform a back-dated update without having to refresh all historical data. SSMS can also be used when bootstrapping to load historical data for large models by incrementally adding/refreshing historical partitions in batches.

 

@bvy

Hi @bvy ,

 

If you have Premium, Premium Per User, or Power BI Embedded, you can do a full refresh/history partition refresh by enabling XMLA Endpoint for the workspace and then connecting to the workspace via the tool (ssms, tabular editor ...).

You can refer to Gabry's and lbendlin's methods.

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...

 

If you are familiar with the PBI rest api, you can also use it to implement enhanced refresh. This also requires Premium, Premium Per User, or Power BI Embedded.
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.