Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
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. |
Cluster URI: | DF-MSIT-SCUS-redirect.analysis.windows.net |
Activity ID: | 967384cf-9812-43cd-83a6-05cad7718c86 |
Request ID: | 529b08fb-2e69-7e9f-2f21-47473662f5d2 |
Time: | 2020-05-11 13:31:20Z |
I have tried
But nothing has worked.
Any suggestions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.