Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RaymondLaw
Regular Visitor

Copy Activity with Warehouse source (lakehouse sql endpoint) validation issue

Hi,

 

I have a task to union two delta table into one. I used copy activity.

It works when i create and save it. However, it fails to validate the source connection when i open the data pipeline after closed.

If i reenter everything into the source tab, it will work again (But it will fail again in next time when i open the data pipeline after closed)

 

It is how it works before i close the pipeline

RaymondLaw_1-1689269943477.png

 

It is how it failed in the validate when i open it after closed. You can notice that it doesn't show the connection string (while the content is still available in the "View JSON code")

RaymondLaw_2-1689270166499.png

 

 

 

Source:

- Data store type: Workspace

- Workspace data store type: Data Warehouse

- Data Warehouse object ID: (the GUID of my lakehouse SQL endpoint) (it doesn't show the lakehouse SQL endpoint for my selection, i need to enter the GUID manually in dynamic content)

- SQL connection string: (connection string of my lakehouse SQL endpoint)

- Use query: Query

- Query "select * from tableA union all select * from tableB" (actually, i used dynamic content, i simplied here)

Destination: (another lakehouse in the same workspace)

(No specific mapping or setting)

 

 

1 ACCEPTED SOLUTION
ajarora
Microsoft Employee
Microsoft Employee

Can you please log a support ticket for this, as this looks like a bug.

View solution in original post

1 REPLY 1
ajarora
Microsoft Employee
Microsoft Employee

Can you please log a support ticket for this, as this looks like a bug.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.