Compare BI Connector with Alternatives
Criteria
Setup
Report automation
Row Limitation
Handling joining key absence
Data Models connectivity
Column name visibility
Power BI certification
Simple setup even for enterprise-level implementations
Supported in Power BI Service via Gateway
No row limits
Retains underlying joins when connecting to Subject Areas
Supported
Column names in Power BI appear are same as the ones created in Oracle Analysis
Certified connector of Power BI
Oracle's Power BI OAC Connector
Complex setup, each user must install Oracle Analytics client tools on their PC
Works only on Power BI Desktop, manual refresh required for Power BI Service
Analysis reports data is restricted to 500k rows
Does not retain any underlying joins
Not supported
Analysis column names appear as s_1, s_2 etc in Power BI
Not a Power BI certified connector
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Complex setup, each user must install Oracle Analytics client tools on their PC |
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Works only on Power BI Desktop, manual refresh required for Power BI Service |
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Analysis reports data is restricted to 500k rows |
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Does not retain any underlying joins |
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Not supported |
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Analysis column names appear as s_1, s_2 etc in Power BI |
Criteria |
|
|
|
Oracle's Power BI OAC Connector |
Not a Power BI certified connector |