Forum Discussion
Helper VIncremental Refresh in the Service - How to schedule/trigger the occasional FULL refresh?
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.
Super UserHello 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.
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.
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 LearnBest Regards,
Gao
Community Support TeamIf 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