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 selec...
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.