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
SCWO
Frequent Visitor

Copy data activity creates no proper delta table with schema in Lakehouse

Hi, 
I'm trying to get data from a REST API with an data copy activity directly into a Lakouse table with using the schema option.
My problem is, that the choosen schema in the copy activity is not taken into account and the table name becomes the schema in Lakhouse. Under that schema a folder is created with the delta file and a delta_log folder.  The preview of the table in Lakehouse is not working therefore.
When I try the same copy activity in a Lakhouse without schema the delta table is created properly. 

Does anybody know what I can do?

 

SCWO_0-1738226883023.png

Thanks for any reply.

 

1 ACCEPTED SOLUTION
nilendraFabric
Super User
Super User

Hello @SCWO 

 

The issue you’re experiencing with Fabric’s Copy Activity ignoring specified schemas in Lakehouse tables is a known limitation in the current preview implementation

 

there are multiple thread in this community around this issues

 

Workaround:

 

I can see you have uppercase letter in your schema name, please make sure all lowercase used

 

https://community.fabric.microsoft.com/t5/Data-Pipeline/Copy-activity-into-Lakehouse-with-schemas-en...

 

If this is helpful, please accept the solution and give kudos

 

 

View solution in original post

3 REPLIES 3
SCWO
Frequent Visitor

@nilendraFabric 
Thanks for your reply.
Unfortunately to write the schema all lowercse is not a working solution.

But now I know I'm not alone with this problem. 😁

Hello @SCWO 

 

Thanks for confirming its not working. 
Its not ideal , but such bugs happens in Preview features. 

please accept this solution so it might help other community users. 

nilendraFabric
Super User
Super User

Hello @SCWO 

 

The issue you’re experiencing with Fabric’s Copy Activity ignoring specified schemas in Lakehouse tables is a known limitation in the current preview implementation

 

there are multiple thread in this community around this issues

 

Workaround:

 

I can see you have uppercase letter in your schema name, please make sure all lowercase used

 

https://community.fabric.microsoft.com/t5/Data-Pipeline/Copy-activity-into-Lakehouse-with-schemas-en...

 

If this is helpful, please accept the solution and give kudos

 

 

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.