Connect to OBIEE RPD using ODBC Connection

That.. looks sad. It doesn't look like this is a properly working driver. Luckily we have other things to try as a workaround :)

1. You can try connecting via using connection string instead of DSN. In PBI, when you click ODBC, instead of picking a DSN, you would type a connection string. I'm guessing it would be like: Driver={yourdrivername}; Host=yourservername; Database="Procurement and Spend - Purchase Orders"

It probably won't work on your first try, you might need to add more parameters or change some of the keys (for example Server (or Hostname) instead of Host, or Db instead of Database etc.) Unfortunately I don't know about OBIEE and I couldn't find an example connection string on the internet (I only looked for a few minutes).

     2. (This is probably easier) On the PBI's ODBC dialog where you pick the DSN, after picking the DSN, you can expand "Advanced Options" and enter a SQL query (e.g. select * from db.tablename)