Not able to select tables from sql databasae... exceed 10.000 tables

[Patronskive]

Is there a way to either see more than 10.000 objects when selecting tables in power bi desktop. After more tables where added to the database, I am no longer able to see the tables far down in the alphabet. Is there a work around to be able to see the tables or at least type the name of the tables to gain access via power bi?

[Patronskive]

@ChrisMendoza, that did the trick. Thank you!

[ChrisMendoza · Accepted solution]

@Patronskive - you can open advanced editor and type in the table.

let
    Source = Sql.Database( server as text, database as text),
    dbo_tableName = Source{[Schema="dbo",Item="tableName"]}[Data]
in
    dbo_table

*edit

in

    dbo_tableName

[Patronskive]

Thank you, Chris. Will try that tomorrow.