Importing dataflow json fails if running native Snowflake SQL

[Stemar_Aubert]

Hello everyone.

I am managing a permium workspace where multiple dataflows are capturing Snowflake data.

While the fact the connector in the service doesn't offer the flexibility of the desktop one, which accepts SQL code and parses it automaticaly into M, there is an issue where exporting a dataflow into json, and importing said json will fail if you have a native query running within it.

[v-jayw-msft · Accepted solution]

Hi @Stemar_Aubert ,

You could try the solution from this topic:

https://community.powerbi.com/t5/Issues/Dataflow-import-requires-AllowNativeQueries-attribute-to-be/... 

Best Regards,

Jay