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

[SorenHElisa]

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

[v-lili6-msft · Accepted solution]

hi, @SorenHElisa 

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Best Regards,

Lin