Forum Discussion

wonga's avatar
wonga
Continued Contributor
10 years ago

Connect to OBIEE RPD using ODBC Connection

I'm trying to connect to the repository for OBIEE using an ODBC connection and the list of subject areas appears to load in Power BI, but I am unable to load any data into Power BI in order to make v...
Need Help
alexrz's avatar
alexrz
Regular Visitor
8 years ago

I anm trying to run that script from Advanced Options => SQL Statement:

 

let
Source = Odbc.DataSource("dsn=OBIPRD", [HierarchicalNavigation=false])
in
Source

 

But receive Unable to Connect error: Details: "ODBC: ERROR [HY000] [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <Source>: Syntax error [nQSError: 26012] .
"

Please advise

anitaberg's avatar
anitaberg
Helper I
8 years ago

Hi! I spent a lot of time struggling to get everything around Oracle to work. One thing that was not obvious was that Microsoft for example did not like the syntax of tnsnames.ora file, It wanted the syntax there exactly as in example on microsoft documentation.

 

Also I made sure I tested user access and roles in SQL Developer before using it i Power BI.