none
Number of tables in Navigator limited to 10,000 RRS feed

  • Question

  • the navigator only shows 10,000 tables after quering a ms sql-database. how can i navigate more  than that?

    Navigator


    • Edited by dietmar07 Saturday, April 25, 2015 11:16 AM missspelling
    Saturday, April 25, 2015 11:15 AM

Answers

  • If you look at the bottom of the navigator, there should be a way to scroll through the list (10,000 entries at a time).
    Sunday, April 26, 2015 11:13 PM
  • I believe there may be a limitation in the navigator UI that doesn't allow paging over the results. Scrolling to the bottom will therefore not work. As a workaround, you can right-click on the database at the top of the navigator and click on "Edit". This will show the navigator, which you can use to filter the result set to the database you wish to access and then "drill down" into it.
    Monday, April 27, 2015 4:52 PM
    Moderator

All replies

  • If you look at the bottom of the navigator, there should be a way to scroll through the list (10,000 entries at a time).
    Sunday, April 26, 2015 11:13 PM
  • I believe there may be a limitation in the navigator UI that doesn't allow paging over the results. Scrolling to the bottom will therefore not work. As a workaround, you can right-click on the database at the top of the navigator and click on "Edit". This will show the navigator, which you can use to filter the result set to the database you wish to access and then "drill down" into it.
    Monday, April 27, 2015 4:52 PM
    Moderator
  • I have Office 2010 SP1 and Power Query 2.40.  I am browsing a database schema with 20,000+ tables.  In the Power Query Navigator, the list of tables preview stops at 10,000 and the filter bar at the top seems to be filtering within the 10,000 set instead of the whole list of tables.  The table I am looking for is beyond the 10,000 set.

    When I click on the schema and use "Edit" in the Navigator pane, I am able to find and select the table that I am looking.  However, when I "Close and Load" or use "Load to", Power Query returns the data results for the list of table names instead of passing the selected table back to the "Navigator" pane.

    I am looking for how to use Power Query to find the table out of 20,000, select it, and then run a query panel on the selected table.

    Wednesday, January 25, 2017 4:58 PM