Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scheduled Refresh Fails with There was an error when processing data in the dataset

Hello,

 

I have a very simple Report that is published to the PBI Service, online.  The data source is a public Web page.  I have configured a Scheduled Refresh of the data from the Web page (the URL is  covidtracking.com/data/state/new-york/).  Updating manually works great.  Unfortunately, the Scheduled Refresh fails with the error:

 

There was an error when processing the data in the dataset.

Data source error:

 

 

{"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 'Total test results Positive + Negative' 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":"Total test results Positive + Negative"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: New York.

 

 

 

Any ideas on what could be causing the Scheduled Refresh to fail?

 

 

 

Dataflow
Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    I wonder if it is having an issue with the + in the column name?

     

    "The column 'Total test results Positive + Negative' of the table wasn't found."

     

    You could check the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We notice that you mentioned "Updating manually works great.", Do you mean the on-demand refresh can update data successfully? Does the query work fine in Power BI Desktop? Does the scheduled refresh success before? Have you tried to re-publish the dataset? Can you find the "Total test results Positive + Negative" column of "New York" Table if you connect the same data source in a blank pbix file?


    Best regards,

     

     

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,


    Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

     


    Best regards,