· Mar 16, 2021

Pass a SQL Query to the IRIS Power BI Connector



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?



Product version: IRIS 2020.3
Discussion (2)1
Log in or sign up to continue

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.