cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

2 REPLIES 2
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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 51 members 1,110 guests
Please welcome our newest community members: