Update custom partition

Hi Peter_23,

Thank you for your follow up query. I apologize for any inconvenience you may have experienced.

As per the details provided previously, I have gone through the code again and made some small changed based on the requirement, so I request you to please try the below provided code if the issue persist, please feel free to reach out to us.

Code1:

$updatedPartitionDefinition = @{

    "createOrReplace" = @{

        "object" = @{

            "database" = "base"

            "table" = "mytable"

            "partition" = "BB"

        }

        "partition" = @{

            "name" = "BB"

            "source" = @{

                "type" = "m"

                "expression" = @(

                    "let",

                    "source = ...",

                    "#\Filtered Rows\"= Table.SelectRows(source, each [#\"Query-filter\"] = \"BB\")",

                    "in",

                    "FilteredRows"

                )

            }

        }

    }

}

Code2:

$refreshRequest = @{

    "refresh" = @{

        "type" = "dataOnly"

        "objects" = @(

            @{

                "database" = "base"

                "table" = "mytable"

                "partition" = "BB"

            }

        )

    }

}

If you have any further queries please feel free to reach out to us we will guide you accordingly. If this post helps, then please give us 'Kudos' and consider Accept it as a solution to help the other members find it more quickly.

Thank you.