Forum Discussion
ronaldbalza2023
Continued Contributor
Continued ContributorODBC connection - Empty tables
Hi everyone, does anyone know why is that showing an empty tables using the power bi default odbc connector? Thanks in advance 🙂
AlexanderPrime
Solution Supplier
Solution SupplierYou may not have been given the proper user access in ODBC to read the contents of tables, can you verify your permission levels in the ODBC data source?. Are you able to read the tables in other programs?
ronaldbalza2023Hi AlexanderPrime , thanks for taking the time on this 🙂
Yes I can view the tables from SQL central. It may be my configuration on the system dsn is differnent from user dsn? My system is in 32-bit while my user dsn is 32/64 bit?User DSN
System DSN
- AlexanderPrime
Hard to say, though a bit of research shows this could be a bug with Power BI still, some articles here may help https://community.powerbi.com/t5/Power-Query/Unable-to-see-the-list-of-tables-connecting-with-odbc/td-p/962491