Forum Discussion

sdiptapaul's avatar
sdiptapaul
Frequent Visitor
8 years ago

Direct Query with custom data connector not working

Hi I have built a custom data connector to use Direct Query feature on Apache Kylin ODBC. Import working perfectly with ODBC but when I connect using Direct Query two problem I stuck after spend two...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi sdiptapaul,

 

Apache Kylin currently doesn’t support query on raw data yet, some queries might fail and cause some exceptions in application. Patch KYLIN-1075 is recommended to get better look of query result.

Power BI and Excel do not support “connect live” model for other ODBC driver yet, please pay attention when you query on huge dataset, it may pull too many data into your client which will take a while even fail at the end.

 

For more details, you can refer to: http://kylin.apache.org/docs23/tutorial/powerbi.html.

 

Regards,

Jimmy Tao

  • sdiptapaul's avatar
    sdiptapaul
    Frequent Visitor
    8 years ago

    Thanks for the response and clarified the question I had. Does custome data connector supports live connect like SSAS for other ODBC providers?

      • sdiptapaul's avatar
        sdiptapaul
        Frequent Visitor
        8 years ago
        Thank you for your response. I am pretty much aware of SSAS has live connect. My question was as multi dimentional cube or tabular cune only works with live connect opposed to direct query, does power bi custom connector supports live connect for other odbc like SupportDirectQuery=true?. Will this be possible if I go through our company support to see if you can provide support for live connect for odbc we are trying to use?