Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

number of tables pulled

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Pragati11
Super User
Super User

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:

Pragati11_1-1628585341307.png

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

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

Anonymous
Not applicable

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

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.