Forum Discussion
Fabric Dataflow Gen 2: The destination table does not exist
I am trying to select a destination target for my dataflow gen 2. When I select a table in the default dbo schema the destination works as intended. When I try to select an existing table in a schema that I created for sales data I get an error "The destination table does not exist". I know the data types for this table are correct because I originally created it with the dataflow gen 2 in the default dbo schema, renamed it, and then moved it to the correct schema.
Hi Alex6161 ,
Thanks for reaching out to the Microsoft fabric community forum.Based on your query, you have not explicitly mentioned it but it sounds like you are using Lakehouse with Schemas enabled as the destination for your dataflow Gen 2.
But as the Lakehouse schemas are still in preview stage there are some limitations currently Lakehouse schemas are not supported by dataflow Gen 2
Source for the above statement:
Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn
This might be the root cause of the error you are experiencing.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you
4 Replies
Hi Alex6161 ,
Thanks for reaching out to the Microsoft fabric community forum.Based on your query, you have not explicitly mentioned it but it sounds like you are using Lakehouse with Schemas enabled as the destination for your dataflow Gen 2.
But as the Lakehouse schemas are still in preview stage there are some limitations currently Lakehouse schemas are not supported by dataflow Gen 2
Source for the above statement:
Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn
This might be the root cause of the error you are experiencing.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank youHi Alex6161
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Alex6161
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi Alex6161
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Thanks and regards