Forum Discussion

Patronskive's avatar
Patronskive
Regular Visitor
4 years ago
Solved

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

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 a...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    4 years ago

    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