Netezza Direct Query in Reporting Services (Aug) Not Working

[jimcush]

Hi all,

While testing the additional data sources that are now available with the August update of the Power BI Reporting Services, I am encountering an issue while connecting to IBM Netezza (Beta) connection, using Direct Query.

I can create/run the report OK in the RS Power BI Desktop and publish it to the Report Server as well.

However, when going to the server ro run it, I get the following error:

 

We do have all of the connectors (ODBC and OLEDB) for Netezza installed on the server.

Any ideas?

Thanks!

--Jim

[v-qiuyu-msft]

Hi @jimcush,

It's a limitation that DirectQuery data connections are not currently supported. For more information, you can see:

Connecting to data sources

Power BI Report Server August 2017 Preview now available

Best Regards,
Qiuyun Yu 

[jimcush]

Hi All,

While testing the additional data sources that are now available with the August update of the Power BI Reporting Services, I am encountering an issue while connecting to IBM Netezza (Beta) connection, using Direct Query.

I can create/run the report OK in the RS Power BI Desktop and publish it to the Report Server as well.

However, when going to the server ro run it, I get the following error:

 

We do have all of the connectors (ODBC and OLEDB) for Netezza installed on the server.

Any ideas?

Thanks!

--Jim

[jimcush]

Hi All,

While testing the additional data sources that are now available with the August update of the Power BI Reporting Services, I am encountering an issue while connecting to IBM Netezza (Beta) connection, using Direct Query.

I can create/run the report OK in the RS Power BI Desktop and publish it to the Report Server as well.

However, when going to the server ro run it, I get the following error:

 

We do have all of the connectors (ODBC and OLEDB) for Netezza installed on the server.

Any ideas?

Thanks!

--Jim