Forum Discussion

adcook's avatar
adcook
Frequent Visitor
5 years ago

Dataset error when refreshing on service, fine with refresh from desktop

I apologize if this was posted twice, but I dont think the last one was submitted. I am trying to refresh and get the following error below. I have searched all ten of my tables, but can't find the value '827-1117-052'. Is there anyway to look into the service logs and find out what table and column this issue is coming from? I feel like it is trying to find a needle in a hay stack. Any thoughts would be appreciated. It is just odd that the desktop client refreshes fine without error, but the service is giving me this problem. 

 

Error:

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Microsoft SQL: Conversion failed when converting the varchar value '827-1117-052' to data type int.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: fffea524-b3d8-4443-b9ad-a830178105c9
Request ID: b07eaef2-42f1-4935-81b4-0f6c7f135a42
Time: 2020-09-17 14:37:59Z

2 Replies

  • Hi adcook 

     

    Sometimes I get similar errors like what you mentioned, but it always resolves itself after a few hours.

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi  adcook 

    Try to upgrade the gateway to the latest version and try it again.

     

    Regards,

    Lin