Linked Service Fabric Lake House

[jovianaditya]

I'm trying to sink my data from Azure Synapse into Microsoft Fabric, so the first thing that I must do is create the Linked Service for Fabric Lakehouse in Azure Synapse Analytics.

There are a few options to enter in the Fabric Workspace name. But there is a problem with the Lakehouse Name. The lakehouse name is not giving me any options to enter (I have several lakehouses in fabric) and automatically gave me the error 'Failed to load artifacts'.  Any solution?

[Anonymous]

Hi @jovianaditya 
Thanks for using Fabric Community.
If you want to sink your data from Azure Synapse Analytics to Fabric, you can use the Azure Synapse Analytics connector which supports Dataflow Gen2 and Data Pipelines.
https://learn.microsoft.com/en-us/fabric/data-factory/connector-azure-synapse-analytics-overview
You can use the copy activity in Pipelines to bring your data into Fabric.

You can also migrate your data present in Azure Synapse Analytics dedicated SQL pools to Microsoft Fabric Warehouse. 
https://learn.microsoft.com/en-us/fabric/data-warehouse/migration-synapse-dedicated-sql-pool-warehou...

For migrating Azure Synapse Spark to Fabric you can refer to this link:
https://learn.microsoft.com/en-us/fabric/data-engineering/migrate-synapse-overview

Why do you want to create a linked service? Can you please explain the scenario so that I can help you better?

Thanks.

[Anonymous]

Hi @jovianaditya 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved.
Otherwise, will respond back with the more details and we will try to help.
Thanks

[IanOliveira]

Hi,

I am having a issue in connecting synapse to onelake. I want to copy some data sitting in one lake to a adsl2 account I have that I use for synapse.

when we try to connect to the one lake we get this message. Is there a tutorial in how to connect to one lake via synapse analytics?

Cheers

[Anonymous]

Hi @jovianaditya 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved.
Otherwise, will respond back with the more details and we will try to help.
Thanks