Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Thanks for any reply.
Solved! Go to Solution.
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
If this is helpful, please accept the solution and give kudos
@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.
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
If this is helpful, please accept the solution and give kudos
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
4 | |
4 | |
2 | |
2 | |
2 |