Forum Discussion
Power BI DirectQuery Error with Simba ODBC – Anyone Seen This or Got It Working?
Hi sahdevISW,
Thank you for reaching out to Microsoft Fabric Community.
Power bi does not support DirectQuery with native sql queries over the ODBC connectors. In this case, the data source like Presto via Simba ODBC does not provide all the DirectQuery push down features expected by power bi.
Even though the preview may work, the final model load fails to load due to power bi’s validation of source capabilities. This is a known limitation for unsupported DirectQuery scenarios.
Since the Presto ODBC connection works in import mode and the query runs fine, please use import mode for now.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Community SupportHi sahdevISW,
Thank you for reaching out to Microsoft Fabric Community.
Power bi does not support DirectQuery with native sql queries over the ODBC connectors. In this case, the data source like Presto via Simba ODBC does not provide all the DirectQuery push down features expected by power bi.
Even though the preview may work, the final model load fails to load due to power bi’s validation of source capabilities. This is a known limitation for unsupported DirectQuery scenarios.
Since the Presto ODBC connection works in import mode and the query runs fine, please use import mode for now.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa