Forum Discussion

bvy's avatar
bvy
Icon for Helper V rankHelper V
1 year ago
Solved

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 a...
Need Help
  • Gabry's avatar
    Gabry
    1 year ago

    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