Forum Discussion

abhisheksingh's avatar
abhisheksingh
Regular Visitor
5 years ago

PowerBI snowflake refresh fails

Hello Team,   I have published a dataset which works on my local desktop but fails on services with below error:   Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessErr...
Need Help
  • abhisheksingh's avatar
    abhisheksingh
    Regular Visitor
    5 years ago

    Hello v-yalanwu-msft,

     

    Thank you for your response.

    I am connecting to Snowflake database via Native connection on PowerBI services.

    Let me know if any more information is required.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi There, I too am suffering the same fate here, again with Snowflake Database via Native Connection on PowerBI Service.

       

      I was able to manually refresh, it obviously refeshes when it is published. Just the Schedule seems to have an issue.

       

       

       

       

      {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","details":[{"code":"ModelRefresh_DataSourceErrorLabel","detail":{"type":1,"value":"Expression.Error: Native queries aren't supported by this value.. <pii>#table({\"Name\", \"Description\", \"Data\", \"Kind\"}, {})<\/pii>. ;Native queries aren't supported by this value.. The exception was raised by the IDbCommand interface. Table: Dataset: General Ledger (P&L Only)."}},{"code":"ClusterUriText","detail":{"type":1,"value":"WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net"}},{"code":"ActivityIdText","detail":{"type":1,"value":"273d8594-6629-4c68-9aa7-205ad8ca66bc"}},{"code":"RequestIdText","detail":{"type":1,"value":"d1b7f0de-f46f-4bd9-a149-5730c93e6a47"}},{"code":"TimestampText","detail":{"type":1,"value":"2022-06-14 18:12:22Z"}}],"exceptionCulprit":1}}}

       

      Anyone able to shed a bit more light on this...

       

       I have gone through this

      https://www.fourmoo.com/2018/01/05/power-bi-turning-off-disabling-native-database-queries/

       

      and no difference as yet.

       

      Regards Mike.