OK i think I must be going mad
A user has inserted a new column into an Excel dataset and this has caused my scheduled refresh in the service to stop working. No matter what I try I cannot seem to get this to resolve. The new column has been added to the table correctly within the Excel file, i have republished the report, I have deleted the dataset and republished the report and dataset and I have published into a different workspace but no matter what I try I am being told by the service that the new column does not exist in the table. Everything is working fine in pbi desktop
I am hoping I have missed something obvious here as this is driving me insane - its just a simple column addition and its caused havoc!!!