SAP Datasphere connection via ODBC Connector

[Sonia_parvin_9]

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 ODBC connector over O-Data connectivity. If anyone can elaborate that will be helpful .

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

• 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

[Sonia_parvin_9]

Hi Experts, Could you please guide urgently us regarding the above query.