topic Netezza Direct Query in Reporting Services (Aug) Not Working in Report Server

Netezza Direct Query in Reporting Services (Aug) Not Working

jimcush — Tue, 12 Sep 2017 17:14:45 GMT

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

Re: Netezza Direct Query in Reporting Services (Aug) Not Working

jimcush — Tue, 12 Sep 2017 17:18:37 GMT

Hi All,

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

Re: Netezza Direct Query in Reporting Services (Aug) Not Working

v-qiuyu-msft — Thu, 14 Sep 2017 02:11:15 GMT

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