Link your Dataverse environment to Dataverse with over 1000 table

[AyushiHarlalka]

Hello 

I am currently using the Microsoft Fabric link available on Dataverse. My platform consists of around 1016 tables that I need to link to my Fabric Lakehouse.

When I attempt to link these tables, I receive a notification that Microsoft Fabric supports only 1000 tables at this time, with plans to support more in the coming month.

Is there any way I can link all my tables to Fabric in the meantime, perhaps using a workaround to create a shortcut? Additionally, could you provide more details on what will be included in the update and a tentative date to support over 1000 tables?

Thank you for your assistance.

[Anonymous]

Hi @AyushiHarlalka ,

It sounds like you're running into a known limitation of Microsoft Fabric. You can try the following to resolve your issue:

1. Temporarily exclude the less important tables before releasing the update, and identify and link the most critical 1000 tables.
2. Consider merging some tables if you can to reduce the total number.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AyushiHarlalka]

Hello @Anonymous 

Thank you for your time.

The project has been running for a very long time, making it challenging to reduce the number of the table. Based on my understanding, in Microsoft Fabric, all tables are selected by default, which complicates the process of reducing the table number in the current situation. Is there any alternative way to create a shortcut in Microsoft Fabric to fetch the data from dataverse?