BUG: Cannot list tables in dbo schema when using Sybase Database connector

[ViliusS]

Did somebody found how to retrieve tables which live in other Sybase database schemas, not the connecting owner schema, when using Sybase Database connector?

If I connect to SQL Anywhere 17 database through SQL Central and create a test table in my own schema, I can successfully retrieve it in PowerBI. However I cannot see any other tables in schemas of other users.

The connecting user has full DBA permissions and `sys` and `dbo` roles assigned. I can clearly see and operate on all tables in SQL Central. I can also see all tables in PowerBI Desktop when using ODBC connector. Just not in PowerBI Desktop when connecting through Sybase Database connector.

EDIT: It looks like I cannot view only tables in `dbo` schema. Sybase Database connector somehow filters out dbo schema completely.

[ViliusS]

It still looks like a serious bug to me. `dbo` schemas usually contain the core data of the database so it is important that it is retrievable. Are there any plans to allow dbo schema to be retrieved through Sybase Database connector? For now we are using ODBC, but native Sybase connector is much faster.

[v-menakakota]

Hi @ViliusS ,

I completely understand your need to use the native Sybase Database connector, especially for performance reasons.
I’d recommend submitting this as a feature request. Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Thank you and Regards,
Menaka Kota.

[ViliusS]

I have created an idea https://community.fabric.microsoft.com/t5/Fabric-Ideas/Allow-to-view-dbo-schema-in-Sybase-Database-c...  but it's not really idea/feature. It's a bug. Microsoft needs to prioritize bugs differently than just going through the list of "ideas". I suspect Sybase connector just has a dbo schema filter hardcoded in, so somebody just needs to remove that filter and fix this bug.

[v-menakakota · Accepted solution]

Hi @ViliusS ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

This is a known limitation with the Sybase Database connector in Power BI Desktop it only lists tables owned by the connecting user and often excludes shared schemas like dbo, even if the user has full DBA privileges.

To work around this issue, Use the ODBC connector instead of the native Sybase Database connector. The ODBC connector provides full visibility into all schemas and tables, including those in the dbo schema. To use it, first set up an ODBC DSN for your Sybase database or use a direct connection string. Then, in Power BI Desktop, go to Get Data > ODBC, select your configured DSN, and connect. I think by this way now be able to browse and access all available tables and schemas without restriction.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Thank you and Regards,
Menaka Kota.