Does ODBC Support Live Connection/Direct query for DWC models?

[Anandhu12]

We were working on connecting SAP Data Warehouse Cloud to Power BI.The main Objective was to search for all the available data sources that connects DWC to power BI.While doing this we faced few issues that are mentioned below

1. Only import connections where available , there was no option for live connection or direct query

2. Is there any row  limit associated with ODBC?

3. We were not able to load models with input parametes.

4. Huge data takes lot of time to import

Is there any solutions or work-arounds for these issues?

[FarhanAhmed]

Does these connections not work for you ?

[Anandhu12]

@FarhanAhmed We are using SAP Data warehouse Cloud,there is no estalblished connection provided by microsoft for this

[FarhanAhmed]

you can take a look at link to see datasources and their connection types

Power BI data sources - Power BI | Microsoft Learn

ODBC does not support Direct Query or Live connection.