Forum Discussion

Miinch87's avatar
Miinch87
Frequent Visitor
2 years ago

Preview List (Over 10000 Tables)

Hello,


I have the following issue:

When I retrieve data through SQL Server, i exceed the preview list of tables due to many tenants in my SQL/NAV-Database, reaching over 10000. This means I cannot find tables from the lower tenants using the search function of the navigator.

Example

 

As a workaround, i use the advanced editor, but I would like to filter the list beforehand.

Question:
Is it possible to restrict the tenants/tables when connecting to the database? SQL?


Does anyone have experience with this issue or has it been implemented a solution before? How else could one solve this problem?

Thanks in advance

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, using a Select SQL statemen in that box will work just fine.

     

    --Nate

    • Miinch87's avatar
      Miinch87
      Frequent Visitor
      2 years ago

      Hello watkinnc,
      i love to hear this. Can you please give me a example for this? 

      Greetings

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Miinch87 Never seen that limitation before. Might have to mention this in the new book on Power Queyr (M) in the accessing data chapter. I don't know of any way around that limitation. It's likely a limitation of the actual connector or the navigator or both and seems like a hard-coded limit. I mean, let's be honest, 10,000 tables/views is a lot. Like, a lot a lot and was probably viewed as a reasonable maximum. Best bet is to open this as an issue in the Issues forum. For now, Advanced Editor is the way to go.