I am connecting to a table through SQL Analysis Server. Within Desktop the table refreshes each time no issues but when I publish to Service, I get the following error message. This has been going on for several days.
Last refresh failed: Mon May 11 2020 09:31:20 GMT-0400 (Eastern Daylight Time) There was an error when processing the data in the dataset.Hide details
Data source error:
We're sorry, an error occurred during evaluation.;Specified cast is not valid. Specified cast is not valid. Specified cast is not valid.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Table Name.