Pass a SQL Query to the IRIS Power BI Connector

Question

Question

Luke Garton · Mar 16, 2021

Hi,

Im wondering if its possible to pass a SQL query through to the Power BI IRIS Connector? I can't currently see an option - and have tried through advance editor to use M Query syntax to attempt this with no luck.

Has anyone else in the community had any luck or know if this is supported?

Thanks.

Product version: IRIS 2020.3

Discussion (2)1

Log in or sign up to continue

Peter Steiwer · Mar 17, 2021

This InterSystems IRIS connector will look at the Tables and BI Cubes that are defined on the system. I believe you can use the ODBC connector if you want to write your own SQL. Another option could be to define a view inside of IRIS and use the view with this connector

0 0

score 0 · Answer 1 · 2021-03-17T17:06:35-04:00

The ODBC connector unfortunately doesnt allow direct query which is the mode im after, hence im in this spot to what capability the IRIS connector has. Hopefully their development team expand the connectors capability (I have a TRC logged internally as well). Good recommendation on the view - unsure if our hosted service allows this permissions but ill look into it more.