Errors when importing table as DirectQuery on IBM DB2 connection

[jvmauricio]

Hello Guru's

We are having a hard time using DirectQuery import on DB2 database as there are errors when we try to get the tables.

Connection Options

Error Encountered when selecting and trying to import 

Is this related to the data source or a bug on Power BI Desktop?

Appreciate your thoughts on this.

Cheers,

JV

[Anonymous]

Hi @jvmauricio ,

Please firstly check if the data works fine in the original data source (IBM DB2).

And try go to Data source settings-->Clear the permission and then re-connect to it. Or try to use Import mode .

In addition, I'd suggest you always use the latest version of PBI to avoid unexpected errors.

Similar threads:

Solved: SQL Server Change Data Source gives "Expression.Er... - Microsoft Power BI Community

SSAS Import - The key matched more than one row in... - Microsoft Power BI Community

Solved: Data source error The key matched more than one ro... - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.