Reached maximum number of tables available in sql server connection

[Anonymous]

Hello,
When I connect to the database via SQL server, I don't see all the tables I have on that DB. It seems that it gets to the maximum of available tables and there is no way to find in this preview the 100% of the tables, not even filtering them by their specific name they appear.

Is there any way to visualize all the tables to be able to select them and import them to the query editor? or is there a maximum of available tables power bi does not allow me to see all the tables?

Thank you

[v-eachen-msft]

Hi @Anonymous ,

If you plan to import several tables, you could use power query directly.

Here is the format. You could also import any table at first, then open advanced editor and copy the codes for reference.

let
    Source = Sql.Database("server", "database"),
    table name = Source{[Schema="",Item="table name"]}[Data]
in
    table name

[ibarrau · Accepted solution]

Hi. I think I have never seen something like this haha. Please check if your ram is not at the top. Another solution that is not very easy but can help you right now is writing a query before getting that screen. When you complete your instance and DB name go to advanced options and write your query "SELECT * FROM Table" to avoid that screen and continue your work.

querydb when connecting

I'll try to check if there is some kind of limitation on that screen.

Regards,

[Anonymous]

Thank you @ibarrau @v-eachen-msft for the answer!

Although I still don't know why that limit occurs, with SQL I have found the table.

Regards