We are running Oracle Analytics Server (OAS) 2025 with an RPD-based semantic model. Security is implemented using Application Roles, Row-Level Security (RAS/Data Filters), and session-variable based access controls.
Our business users want to use Power BI for self-service reporting. We currently have access to a third-party connector solution, but we are evaluating whether there is a native Oracle-supported approach that would allow Power BI consumption while maintaining OAS security and governance.
Specifically:
- Can OAS semantic models, subject areas, or DV datasets be exposed to Power BI Service/Desktop using a supported Oracle approach?
- Is it possible to publish or share OAS/DV datasets for Power BI consumption while maintaining:
- Application Roles
- RAS/Data Filters (Row-Level Security)
- Session-variable based security
- End-user identity propagation/pass-through authentication
- Has anyone implemented a Power BI → OAS architecture where OAS remains the central semantic and security layer and RAS continues to be enforced?
- Are there OAS 2025 APIs, semantic model endpoints, or query services that support this use case?
- If Power BI connects directly to the Oracle database, our assumption is that RPD business logic and RAS would need to be recreated outside OAS. Has anyone found an alternative architecture that avoids this duplication?
- Also, there is a plan to upgrade to OAS 2026 —will that make things much more feasible for this requirement..
Our primary goal is to determine whether governed OAS/DV datasets can be exposed to Power BI without losing OAS-managed RAS security and without relying on third-party connectors.
Any guidance, reference architectures, or real-world implementation experience would be greatly appreciated.
