Forum Discussion

XhevahirMehalla's avatar
XhevahirMehalla
Icon for Helper IV rankHelper IV
8 months ago
Solved

Limits on objects showing for a schema on Oracle db

Hello -

 

We want to extract data from an Oracle OCI database from PBI service and or PBI desktop/Builder.

However when we try that we can only see 10000 objects per a schema and not the rest of the db objects.

 

Is this limitation on the tool or is smth that we need to set somewhere?

 

Thanks in advance!

Xhev

 

Need Help
  • BeaBF's avatar
    BeaBF
    8 months ago

    XhevahirMehalla Hi!

    Power BI has a built-in limit: when it loads metadata for a schema, it will only show up to 10,000 objects (tables, views, etc.). If a schema contains more than that, Power BI stops listing additional objects, which is why the rest don’t appear in the Navigator.

    Unfortunately, this limit can’t be changed, there’s no setting in either Power BI or Oracle that allows you to increase it.

     

    Power BI can query objects even if they don’t appear in the schema list. Try to use a SQL Query as:

    SELECT *
    FROM your_schema.your_table

     

    BBF


    💡 Did I answer your question? Mark my post as a solution!

    👍 Kudos are appreciated

    🔥 Proud to be a Super User!

2 Replies

  • BeaBF's avatar
    BeaBF
    Icon for Super User rankSuper User
    8 months ago

    XhevahirMehalla Hi!

    Power BI has a built-in limit: when it loads metadata for a schema, it will only show up to 10,000 objects (tables, views, etc.). If a schema contains more than that, Power BI stops listing additional objects, which is why the rest don’t appear in the Navigator.

    Unfortunately, this limit can’t be changed, there’s no setting in either Power BI or Oracle that allows you to increase it.

     

    Power BI can query objects even if they don’t appear in the schema list. Try to use a SQL Query as:

    SELECT *
    FROM your_schema.your_table

     

    BBF


    💡 Did I answer your question? Mark my post as a solution!

    👍 Kudos are appreciated

    🔥 Proud to be a Super User!

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    8 months ago

    What you’re seeing is a product limitation of the Oracle connector’s metadata/navigation experience, not an Oracle OCI database setting. Power BI (Desktop / Service / Report Builder) uses the connector to enumerate schema objects and display them in the Navigator. For very large schemas, the connector/UI applies a cap (commonly experienced around 10,000 objects) to keep metadata discovery usable and prevent timeouts/memory issues. Instead of searching table:

     

    Power BI Desktop → Get Data → Oracle database → Advanced options → SQL statement

    SELECT ... FROM schema.table_name