The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |