Forum Discussion

SorenHElisa's avatar
SorenHElisa
Icon for Helper I rankHelper I
7 years ago
Solved

Internal error in dataflow connecting to Netezza via OleDB, ODBC and native driver

Hi,

 

I'm trying to connect to a Netezza database from dataflow. 

What I have tried:

OleDB: direct SQL command (cannot select table from list, due to errors)

Native driver: select full table (no option to write SQL) 

ODBC: select full table AND SQL command

 

All four (4) versions give internal error.

 

I'm beginning with empty query (since there is no option for Netezza in databases) and copy-pasting the M code from a Desktop version of Power BI. This is an example using the OleDB driver loading a time dimension:

let
Source = OleDb.DataSource("provider=NZOLEDB;data source=<host name>;initial catalog=<database name>", [Query="Select * from dim_time"])
in
Source

 

I'm connecting to a gateway where the appropriate connection created (works when refreshing a Power BI Report created in Desktop). In data flow I get an error with these IDs:

 

Internal error Request ID: 802757b4-b5de-d36c-c547-ba9540fb5167

Activity ID: 820fe508-909c-4668-9b40-b91513b56802

 

Could you please have a look at these IDs?

 

Since I'm using a browser with Swedish as the main language, the query name was automatically created as "Fråga", wich includes a "special" character. Even if I change this, the error still remains, so this is (probably) not the issue. Or is it?

 

Best regards,

Sören

1 Reply