Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How number of tables/views can we see when we connect to a schema in a Database?
Solved! Go to 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
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
Is there any option to increase the number tables/views power bi can pull from a particular schema?
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