Forum Discussion
amir_mm
Helper III
Helper IIITabular 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 ...
amir_mmHelper III
Helper IIIThe table has 9M rows. I created 4 partitions in Tabular editor 2 (for 2024, 2023, 2022, 2021) using RangeStart and Range End. But when I refresh Power BI service, it only refresh the last partition (2024) and the other years won't be refreshed. For those years I used PowerShell in Azure Runbooks (with query below) and I could refresh 2023 but I cannot refresh 2022 and 2021 because of Power BI memory capacity limit. I need to be able to refresh all partitions sequentially to avoid memory capacity error.
Any idea is really appreciated.
$Query ="{
""refresh"": {
""type"": ""automatic"",
""objects"": [
{
""database"": ""My_Dataset"",
""table"": ""Orders"",
""partition"": ""2023""
}
]
}
}"