Forum Discussion
Issue with Snowflake Source
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
2 Replies
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
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.
