Create a custom connector where we can directly connect to OBIEE RPD and subject areas. The Metadata can be refreshed which can be easily used to build the reports & visualize the data in MSBI.
check out https://www.biconnector.com/
Connector to query OBIEE report and subject areas directly. Where OBIEE can be a cloud based service with https connectivity