Forum Discussion
Connect to OBIEE RPD using ODBC Connection
Hi wbsissonii
Sorry for the late reply, I just came back from vacation as well :)
When we change the default query by making HierarchicalNavigation=false, we're sacrificing the nice navigator experience where you can load multiple tables in 1 go. But when we do this, it just loads 1 table and you can't pick multiple tables with checkboxes. But it's still very easy to do it, you can just add a new query to the same ODBC datasource to load your other table.
About the Subject Areas (I'm assuming that's the equivalent of a catalog which contains schemas in OBIEE? I don't have experience on OBIEE), when we turn the HierarchicalNavigation off, we're only seeing the default catalog. This means if you want to access other Subject Areas, you can create new DSNs for them, and when you're creating them, pick the desired Subject Area as the default catalog when you're creating the new DSN.
Thanks
Hi,
i'm using below M query to connect to RPD
let
Source = Odbc.DataSource("dsn=MYDSN", [HierarchicalNavigation=false])
in
Source
on month of october it used to work, now if i use the same code it throws error.. i don't know what i'm doing wrong..
Error:
DataSource.Error: ODBC: ERROR [08004] [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=MYDSN
OdbcErrors=Table
PBI Version:
PBI Version: 2.42.4611.901 64-bit (January, 2017)
my connections works.. i can connect online RPD and able to test ODBC and get list of Subject areas from my machine.