ERROR ADBC: InternalError [] [Snowflake] 002031 (42601): SQL compilation error: Unsupported subquery

[KONERU_MAHITHA]

Hello Powerbi Community,

I am getting this error from a sql view that has no issues in snowflake but is throwing this error when i load the sql view in powerbi...can anyone help what could i be doing wrong ....

The path is as follows: Get Data -> Connect to Snowflake and add a small query in advanced options and it throws below error from this sql view.

ADBC: InternalError [] [Snowflake] 002031 (42601): SQL compilation error:
Unsupported subquery type cannot be evaluated"

Can anyone please help ...thank you

[v-sathmakuri]

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!!

[lbendlin]

Do you have the same issue with the legacy Snowflake connector?

[KONERU_MAHITHA]

It looks like it's only an issue with one particular column. But the column is totally fine in snowflake. Legacy connector was fine as well. It started the issue just recently.

[lbendlin · Accepted solution]

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 .