Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |