Forum Discussion
Does ODBC Support Live Connection/Direct query for DWC models?
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?
3 Replies
FarhanAhmedCommunity Champion
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.
- FarhanAhmed
Does these connections not work for you ?
FarhanAhmed We are using SAP Data warehouse Cloud,there is no estalblished connection provided by microsoft for this
