Forum Discussion
Server Error. Message : The metadata for the Delta table 'table_name' with the version 'n' could not
Hi v-karpurapud
It is not possible for us to make changes in the source data due to limited access. What we have done is to delete and recreate the shortcuts for now. Most of the time that also won't help and will get this error "[{"message":"\"Msg 24596, Level 16, State 31, Line 1\""}]" from SQL Endpoint. The same data is used in oru databricks pipeline as well which is the primary and there is no issue there for the same tables.
We have done this as a part of PoC to see the potential and possibilities in Fabric. We expect a fix from Fabric for this issue as the source table can change on a daily basis & the same issue in Fabric is not coming in Trino which connects to the Databricks metastore. We are about to open a ticket for this.
Thank you.
Hi abhilash_o_p
Thank you for the update. We understand you have limited access to the source data and cannot modify the Delta table directly. As noted, recreating the shortcut is only a temporary workaround and does not always resolve the problem.
This issue arises because Microsoft Fabric shortcuts always point to the latest Delta log version. Currently, Fabric does not support reading historical versions or handling incomplete Delta commits as other platforms like Databricks or Trino do, especially when using the Databricks metastore. Fabric’s shortcut approach is stricter in interpreting Delta metadata.
We suggest submitting a support ticket to Microsoft so the product team can review your situation and consider it for resolution or future improvements.
You can submit a ticket through the Microsoft Power BI Support Portal:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
- abhilash_o_p1 year agoFrequent Visitor
v-karpurapud - Thank you for your help. I have submitted a ticket for the same.
- v-karpurapud1 year agoCommunity Support
Hi ,
Thank you for keeping us informed. I hope your issue gets resolved soon. If it does, please update us here.
Best Regards,
Karpurapu D. - v-karpurapud1 year agoCommunity Support
Hi abhilash_o_p
Could you let us know if the issue was resolved after creating the support case?
Thank You.- abhilash_o_p1 year agoFrequent Visitor
Hi v-karpurapud - This is still not resolved. No update on support case as well. I believe it might take some time. Will update here when I get a update from the Fabric support team.