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

[ddawkins]

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?

[v-lid-msft]

Hi @ddawkins ,

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,

[v-lid-msft]

Hi @ddawkins ,

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,

[Greg_Deckler]

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".