Forum Discussion
ERROR ADBC: InternalError [] [Snowflake] 002031 (42601): SQL compilation error: Unsupported subquery
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Hi KONERU_MAHITHA ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you lbendlin for the prompt response.
Some subqueries are not supported in DirectQuery mode, so consider switching to Import mode. If the issue still persists while loading the view into Power BI, try creating a simplified version of the view and load it into Power BI using Snowflake as the source. If the simplified view loads successfully, the problem likely lies within the original view's complexity.
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 & Regards,
Rekha,
Customer Support Team!!