Connecting Power BI to Oracle DB Incorrectly Displays BIN Objects

[mariotalavera]

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.

[v-caliao-msft]

@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