question

UD-6072 avatar image
0 Votes"
UD-6072 asked KranthiPakala-MSFT commented

Issue while changing resource group in synapse sql

I am getting below error message while changing the resource group. Kindly help:


140258-image.png


azure-synapse-analytics
image.png (183.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please let me know if anyone having any idea about this issue. Thanks.

0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @ud-6072,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

As per my understanding you are trying to move your Azure Synapse workspace from one resource group to another. Please correct if I misunderstood your requirement.

Unfortunately as of now, it’s not possible to move Azure Synapse Analytics workspace across resource groups, subscriptions and tenants. But product team is actively working on delivering this feature. But we do not have an ETA at the moment.

You can refer to this doc where it confirms that the move operation isn't supported for Azure Synapse resource type: Microsoft.Synapse - Move Operation

140366-image.png


But in the mean time as a workaround you can try below:

  • Azure SQL scripts, Notebook can be imported/exported from Azure Synapse Studio.

  • For pipelines, linked services you can download the support files and copy the JSON template and create a new pipeline using the same JSON template. (As explained in this thread - Azure Data Factory V2 Arm template to Synpase Data Integration without Git)

  • You can also use Azure PowerShell modules for to import and export.

For more details, refer Az.Synapse.

Hope this helps. Do let us know if you any further queries.



  • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators




image.png (87.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank You for the response @KranthiPakala-MSFT.

Do you have any idea how to read D365 finance and Operations from ADLS to synapse SQL? FnO data is stored in ADLS in csv, but header is store separately in JSON file. I need to create a view in Synapse SQL for Power BI reporting. Kindly let me know if you have any idea on this. Thanks in advance.

0 Votes 0 ·

Hi @ud-6072,

Thank you for your response. As the followup ask is different than the original issue of the thread, I would recommend you to please open a new thread so that it would clear for the community members who read this requirement.

Also if the above response answers your original query, please do consider to click 130616-image.png and upvote 130671-image.png for the same as it can be beneficial for others who read this thread.

Thank you

0 Votes 0 ·