Forum Discussion
How do I obtain the specific original table path when using external data share
Hi guys,
I have a mirror database with multiple schemas, each with multiple tables. In tenant A, I created an external data share for it. In tenant B, when I received the external data share, it only returned the pathid and name. The name here is just the name of the table. So, how can I distinguish between different schemas with the same table name?Is there any way to obtain the original schema information?
I need to obtain specific shema or path, not pathid, or is there any way to resolve pathid?
4 Replies
Hello Jason_Xu,
Thank you for reaching out to the Microsoft fabric community forum.
Currently, when receiving an External Data Share in another tenant, only the pathId and table name are shown in the received table list, and schema information (like dbo or demo) is not directly included. Additionally, there’s no built-in way to decode the pathId back to its schema or original path in the receiving tenant.If this is a feature you'd like to see, We encourage you to submit your scenario or idea to the Fabric Ideas Forum. If it gains enough upvotes, the Microsoft team may consider implementing it in future updates.
Feel free to reach out with any further questions.
Best regards,
Ganesh Singamshetty.Hi Jason_Xu,
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum, we’ll be happy to assist.Thank you for being part of the Microsoft Fabric Community.
Hi v-ssriganesh
Recently, I was dealing with other tasks.I've submitted in the Ideas ForumNeed API for parsing pathid in external data share - Microsoft Fabric Community
Thank you.
