I have a PowerBI report which reads data from different web sources. I can refresh the data from Desktop and everything is OK. When I do "Refresh now" or Scheduled refresh in the browser, I get the following error message:
Last refresh failed: Fri Jul 08 2016 08:46:54 GMT+0300 (FLE Daylight Time)
There was an error when processing the data in the dataset.Hide details
|Data source type:|| |
|Data source error:||The column 'Header' of the table wasn't found.|
I have checked the sources several times and cannot see any issues with Header columns.
If I go to Scheduled refresh and check Refresh history, recent Scheduledrefreshes show Failed with "There was an error when processing the data in the dataset." and all OneDrive refreshes are Completed.