Forum Discussion
Dataflow Gen2 :Unable to create a table on the Lakehouse SQL catalog due to metadata refresh failure
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Hi mandania ,
Based on the error message and the information provided, the issue appears to be related to a failed metadata refresh when attempting to create a table in the Lakehouse SQL Catalog.
The error message instructs TridentLakeClientUserException that if you already have the table in Lakehouse, then simply drag and drop it and recreate it. You must have the exact same schema, or if the schema of the data source has changed, then you may need to update the mapping of the dataflow to reflect the new structure.Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I was able to get some help from the fabric support and they managed to solve the problem. This is what they replied "In the previous cases, Product team has identified this bug is caused due to ownership of AD token failure and they have resolved it and took actions so that it will not occur again" My guess is this, the lakehouse that was throwing the error was owned by one of my other colleague who no longer works for us. We had removed his account (that was used to create the LH) and i think this caused a chain of error. unfortunately LH ownership is not something that you can change on fly, so you have to keep in mind that if the account holder is no longer with the compnay , you should probably not remove this person account until fabric comes with a solution.
Hi mandania ,
Your comments and feedback are valuable to us and very much appreciated.
Best regards,
Adamk Kong