Forum Discussion
Errors when importing table as DirectQuery on IBM DB2 connection
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
1 Reply
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.
