number of tables pulled

[Anonymous]

How number of tables/views can we see when we connect to a schema in a Database?

[Pragati11]

HI @Anonymous ,

When you connect to a data-source like a database (SQL Server) from Power BI, you will see the list of tables in the database as shown below:

The highlighted number in the above screenshot, tells you the number of tables in the database.

Thanks,

Pragati

[Anonymous]

Is there any option to increase the number tables/views power bi can pull from a particular schema?

[Anonymous · Accepted solution]

Hi @Anonymous,

I'm not so sure why you need to increase these numbers, normally power bi will show all valid and recognized objects.

If you mean the max amount of power bi desktop data model limitation. Current power bi desktop seems not mention limitations on data table amount, they should according to data table size and available device memory/hard disk size.
BTW. you can take a look at the below blog to know more about these limitations:

The Conceptual Data Model and Limits | Microsoft Power BI Blog | Microsoft Power BI

Regards,

Xiaoxin Sheng

[Pragati11]

Hi @Anonymous ,

What do you mean by: Is there any option to increase the number tables/views power bi can pull from a particular schema?

Power BI can pull any number of tables you want to bring in from a database.

Thanks,

Pragati