Forum Discussion

KHaugen's avatar
KHaugen
New Member
1 year ago
Solved

Synpase in place upgrade to 3.4

Currently using Synapse 3.3 in PowerApps Synapse Link for Dataverse and D365 F&N tables.  Attempting to upgrade to Synapse 3.4.  Documentation states creating new sparkpool and then option will be available to perform an inplace upgrade.  New sparkpool created with same permissions as existing sparkpool but option to perform upgrade does not appear in Powerapps.  Any insights appreciated.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi KHaugen,

    Thank for reaching out in Microsoft Community Forum.

    Please follow below steps to visible upgrade option in power apps;

    1. please make sure that the you're on the correct power apps environment where the azure synapse link profile is active and linked to the spark pool whatever you want to upgrade

    2. please check that the new spark pool with Apache spark 3.4 is deployed and visible in azure synapse

    3. Make sure that the Azure Synapse Link profile is properly linked to your Dataverse environment and Spark pool and check the compatibility with latest delta lake versions

    Thank you,
    Pavan.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi KHaugen,

    We hope your issue has been resolved, If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.

    If you need any further assistance, feel free to reach out.

    Thank you,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi KHaugen,

    Thank for reaching out in Microsoft Community Forum.

    Please follow below steps for if  upgrade option doesn't appear in power apps;

    1. Make sure the new spark pool set Apache Spark 3.4 and met the hardware specifications of the current pool

    2. make sure you've the required roles like system adminstrator and synapse adminstrator with access of azure delta lake storage(ADLS) Gen2.

    3. The upgrade version is starts when the new delta lake conversion job is triggered by a data change.

    If you found this post helpful, please consider marking it as "Accept as Solution" and select "Yes" if it was helpful. help other members find it more easily.

    Thank you,
    Pavan.

    • KHaugen's avatar
      KHaugen
      New Member

      Permissions are identical to current spark pool but option to perform the upgrade is not visible based on the documentation (Step 3)

      In-place upgrade to Spark 3.4:

      1. Sign in to Power Apps and select your preferred environment.
      2. On the left navigation pane, select Azure Synapse Link. If the item isn’t in the left navigation pane, select …More and then select the item you want.
      3. Open the Azure Synapse Link profile, and then select Upgrade to Apache Spark 3.4 with Delta Lake 2.4.
      4. Select the available Spark pool from the list, and select then Update.
      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi KHaugen,

        Thank for reaching out in Microsoft Community Forum.

        Please follow below steps to visible upgrade option in power apps;

        1. please make sure that the you're on the correct power apps environment where the azure synapse link profile is active and linked to the spark pool whatever you want to upgrade

        2. please check that the new spark pool with Apache spark 3.4 is deployed and visible in azure synapse

        3. Make sure that the Azure Synapse Link profile is properly linked to your Dataverse environment and Spark pool and check the compatibility with latest delta lake versions

        Thank you,
        Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi KHaugen,

    I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
    If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
    If you need any further assistance, feel free to reach out.

    Thank you,
    Pavan.