cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Datasphere to Power BI connectivity via OData API

Sonia_parvin_9
Discoverer
0 Kudos
132

Hi,

I need to connect Microsoft Power BI via SAP Datasphere. It can be done in both ways via ODBC connector or O-Data connectivity. What are the present Pros & Cons of OData API connection over ODBC connector. If anyone can elaborate that will be helpful .

Also there are few questions regarding Import connection between Power BI & Datasphere via OData.

  • Are Data builder & Business Builder both supported here or not ?
  • If Analytical model is exposed to Power BI via import mode is there any data volume limitation present or how much data volume is allowed ?
  • There are few problems already present like Aggregation, Hierarchy is not supported, if parameter is present then value needs to be passed like that. Apart from these problems is there any major problem which can be blocker ? Also, is there any SAP route map for solving blockers ?

    Please let me know about above questions mentioned. Any SAP notes relevant will be helpful. 

     

    Thanks & Regards

    Sonia Parvin

Accepted Solutions (0)

Answers (0)