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:
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?