Forum Discussion

saj's avatar
saj
Helper III
4 years ago

Error on Service not on Desktop

Has anyone come across an issue where the Desktop version of a dataset refreshes fine but the service version keeps failing?

 

I've got a dataset that has been refreshing every day for several months and today it has failed.

 

 

 

{"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":"The column 'AuditSubType' of the table wasn't found."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"AuditSubType"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Audit Individuals.

 

 

 

I've checked.

  • The PBIX refreshes fine in Desktop, no errors
  • I've tried refreshing the dataset on the Service several times and it keeps whinging. The table name can be different even to the point that AuditSubType doesn't exist at any stage in the M steps.
  • I've tried publishing the dataset as a new version and it still errors.

 

Thanks

2 Replies

  • nitishsh91's avatar
    nitishsh91
    Solution Supplier

    Hi saj 

     

    Are you using an excel file in your dataset and does it have dyanmic column names or something adn you are removing columns in the query?

    • saj's avatar
      saj
      Helper III

      Hi nitishsh91 thanks.

      No it's SQL but either way the refresh succeeds in Power BI Desktop and fails in the Service (same source data).