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
