Forum Discussion

mariotalavera's avatar
mariotalavera
New Member
9 years ago

Connecting Power BI to Oracle DB Incorrectly Displays BIN Objects

Error Description

Navigator Submodal Window displays Oracle's BIN$ Objects.  These objects are deleted objects (tables, indexes) that the user does not have access to.  These items should not show.  

The fact that Power BI fetches 1000 objects only worsens state since a schema may have many more objects deleted than current. I.E. - Power BI ends up not fetching some or all the current objects because only 1000 will show and user can then NOT select tables needed.

 

Error View

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Running 'show recyclebin;' at the sqplus prompt shows that following:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Workaround
Run 'purge recyclebin;' from sqplus to have all these items removed. Refectching objects afterwards works proplery.

 

Show and Tell
Tips and Tricks

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    mariotalavera,

     

    Run 'purge recyclebin;' from sqplus to have all these items removed. Refectching objects afterwards works proplery.
    Thank you for sharing the useful infomartion, it will help others who have the similar issue to get the solution easily.

     

    Regards,

    Charlie Liao