IBM DB2 - No tables shown in Navigator, there are only schemas

[bbaser]

In Power BI Desktop, it seems connected to DB2 database. Then Navigator opens and shows all schemas but I can not see any table in them. How can I select tables?

[v-ljerr-msft · Accepted solution]

Hi @bbaser,

According to your  description above, you may be experiencing security related issues for the account you're using to connect to your IMB DB2 database . A fast and quick way to problem investigate if its security related or not, use an account with SYSADM authority to connect to the database to see if you can see tables in each schema.

In addition, you can also try importing data from database using Native Database Query to see if it works.

Regards

[bbaser]

Thanks for your reply @v-ljerr-msft. The account I am using has the authority.

I could import data by using native database query, yes. This would solve the import problem.