How to filter data in Power BI desktop in direct query mode (IBM DB2)

[dssharma]

Hello,

Could anyone please educate me on how to filter the data in power bi in direct query mode. We are using a DB2 database and there is no option to connect to the DB2 database in import mode and hence I am not able to filter the data. The database server is located remotely and there are some millions of rows. I could do the filtering in Import mode but not in Direct query mode.

Could anyone please help.

Thanks in advance.

DS Sharma

[v-yuezhe-msft]

Hi @dssharma,

Do you get the option “Edit Query” by righting click the table in Power BI Desktop? If the option exists, you are able to filter data in Query Editor.

If the above option doesn’t exist, expand SQL Statement(optional) when you connect to IBM DB2, write a specific database query that returns your expected data.

Thanks,
Lydia Zhang

[dssharma]

Hello Lydia,

Thanks for your message. I have done some filtering in the edit query and I have clicked on Close and Apply. After that the data starts loading and I get this error message. Could you please help.

[Karen_Payne]

We received the same error, performing the same steps outlined above.  Is there a "work-around"?

[dssharma]

Hello Karen,

What type of Connection are you using? ODBC or .net connector for DB2. Can you try with .net Connector for DB2 and then try filtering.

DS Sharma