Connect to OBIEE RPD using ODBC Connection

This thread seems to have died  ....

To be clear. This is for the OBIEE BI Server ODBC connection not the Oracle DB connection.

The BI Server hosts a meta data model over one or more physiucal data stores eg DBs, Excel, WS, etc. The ODBC driver provides a SQL interface that model.

We can use the driver to execute logical SQL against the BI Server model. However, what is more desirable is to be able to select 'tables' from the model and load those into PBI. As has been noted elsewhere, we can see all of the subject areas in the model when we just connect to the BI Server ie no SQL in the Advanced box. But we can not see any lower to be able to select whole tables.

Using the Advanced editor script noted in other posts with the Dec 2018 release.

I can see all the meta data about the tables in the model. 

There is a table column. If Iselect a specific row in the data set (for a given table) and then expand the table field. I then get all of the columns in that table. However, all I then get is a single row of data with null values.

It would be good even if this process worked but its not. The desirable behaviour is to select whole tables in the UI.

Thanks

Tim