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
wonga's avatar
wonga
Continued Contributor
10 years ago

Hi arify, I sent the requested information earlier today. Is there any way you can confirm receipt of my error submission?

arify's avatar
arify
Microsoft Employee
10 years ago

We got your email, thanks :)

 

Actually, when you set the HierarchicalNavigation to false, can you also remove the last step?

 

So, your M query should be like this:

 

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

 

See if that works :)