since two days the PowerBI dataset on the server which was scheduled to automatically refresh, gives an error:
Bronbestand_Medicinfo_data has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
Microsoft SQL: Invalid column name 't0_1'.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Next refresh for Bronbestand_Medicinfo_data is scheduled for April 30, 2020 11:00 UTC.
This is strange, because so far as I know, nothing has changed. When I refresh the same dataset in PowerBI desktop, then I don't get the error. But when I publish the report to the PowerBI server and I refresh, then I get this error.
Unfortunally the error doesn't say which table has the problem and I have many tables.