Issue with Snowflake Source

[Krishanu]

Hi,

We are using Snowflake as a datasource. When using incrmental refresh for a summary fact table and using the detail fact table in Direct query mode. It started giving error -  "ExecuteXmla failed with result"
Log shows this - 
"Datasets with Incremental Refresh and DirectQuery tables on data sources other than SQL Server, Teradata and Oracle are not allowed."
Any workaround possible? Difficult to understand why Snowflake being a SQL data source like above 3 , will behave differently.
Thanks for your help in advance.
Regards,

Krish

[Anonymous]

@Krishanu 

I would suggestion you to create a support ticket see if there is a workaround with this incremental refresh. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[harshnathani]

Hi @Krishanu ,

See if these help you

https://community.powerbi.com/t5/Service/Power-BI-Gateway-Issue-Snowflake/m-p/806322

https://community.powerbi.com/t5/Service/Connecting-Snowflake-to-Dataflow/m-p/914890

https://community.powerbi.com/t5/Service/Power-BI-service-to-Snowflake-connection/m-p/930827

Regards,

Harsh Nathani