Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Reached maximum number of tables available in sql server connection

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

 

Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    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,

3 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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