Forum Discussion
Tabular editor 2 and incremental/full refresh
Hello, Below is part of the PowerShell script that I'm using in Azure Runbooks to refresh my PBI dataset. I included "only one table" in this script for refreshing because this is a huge table with ...
Hi amir_mm ,
You can try the following:
Use incremental refresh in Power BI Desktop.
Large semantic models in Power BI Premium - Power BI | Microsoft Learn
Use SSMS to refresh partitions individually.
Avoid the full refresh with Incremental Refresh in Power BI (Premium) - YouTube
The choice is to use a hybrid table, which is a table with one or more Import partitions and a DirectQuery partition.
Verified that the partitions are correctly configured in Table Editor 2 and tried to check for specific partitions in the script.
"partition": "YourPartitionName"
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.