cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jimcush Frequent Visitor
Frequent Visitor

Netezza Direct Query in Reporting Services (Aug) Not Working

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:

 

 

 RS Aug Issue 2.JPG

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

 

Any ideas?

Thanks!

--Jim

2 REPLIES 2
Highlighted
jimcush Frequent Visitor
Frequent Visitor

Netezza Direct Query in Reporting Services (Aug) Not Working

 

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:

 

 

 RS Aug Issue 2.JPG

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

 

Any ideas?

Thanks!

--Jim

Moderator v-qiuyu-msft
Moderator

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

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 142 members 1,755 guests
Please welcome our newest community members: