Forum Discussion

Simsy's avatar
Simsy
Frequent Visitor
5 years ago
Solved

Scheduled Refresh Failing

Hi,

I'm hoping somebody can help me understand this error message.

The dataset refreshes fine in Power Bi Desktop, but fails during  my daily scheduled refresh.

 

This has been happening for over a week, I'm unable to find any help elsewhere and don't know where to try next.

 

Many thanks 

 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>5 arguments were passed to a function which expects between 2 and 4.</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Arguments","detail":{"type":1,"value":"{Table.FromRecords({}), \"Index\", 1, 1, number}"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: ppm_dwh DWH_EMR_ORACLE_FIN_GRAPH_V.

  • Simsy's avatar
    Simsy
    5 years ago

    Thanks for the quick reply Vanessafvg,

     

    I don't have control of the gateway, but I will ask.

     

    I will delete & republish on Monday.

     

    I get the same error with a Manual Refresh

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion

    is is your gateway software up to date?

    and on a whim, if you its possible to do, have you tried deleting and republishing?

     

    if you manually refresh in the service do you get the same error?

     

    • Simsy's avatar
      Simsy
      Frequent Visitor

      Thanks for the quick reply Vanessafvg,

       

      I don't have control of the gateway, but I will ask.

       

      I will delete & republish on Monday.

       

      I get the same error with a Manual Refresh