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
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.

alexrz's avatar
alexrz
Regular Visitor
8 years ago

Thank you to your responce: but I have all the necessary connections and roles. I added this script trying to fix the problem that is the main subject all this long discussion: When I open OBIEE RPD in PowerBI - I cannot drill off a Subject Level. I can use Select query as a data source & Power BI  run it (i.e it finds all the necessary tables & columns from the physical Model) , but when open RPD itself I cannot click and expand any subject area.

This topic is discussed and somebody earlier  suggested to add script

 

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

 

 to the Advanced Connection: I added it to the SQL Box of Advane Option and got connection error. So my question was : Have I added it to the proper place and if so - what may be wrong?

Appreciate any help