Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Directquery DB2 support - Can't see tables in other schemas

Submitted by Anonymous on ‎06-14-2019 10:56 AM

After a directQuery connection, we can see a list of DB2 schemas.  All the schemas are empty except the one that has the same name as the DB2 user we used to connect with. Note that there is nothing wrong with the DB2 privileges. 

 

Any other standard db tool we have tried can see all schemas and all tables according to privileges without any issues.

Status: New
See more ideas labeled with:
4 Comments (4 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎06-18-2019 01:58 AM

Hi @Anonymous, 

 

Please connect to the same IBM DB2 server in Import mode, check if the desired schema. 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable
‎06-18-2019 08:01 AM

Same problem on import mode.

v-qiuyu-msft
Community Support
Community Support
‎06-24-2019 02:28 AM

Hi @Anonymous, 

 

Please create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable
‎06-25-2019 07:58 AM

Can't do it yet as we don't have a Power BI Pro subscription. We are just evaluating the product.

Idea Statuses