Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
hi @adcook
Try to upgrade the gateway to the latest version and try it again.
Regards,
Lin
Hi @adcook
Sometimes I get similar errors like what you mentioned, but it always resolves itself after a few hours.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 18 | |
| 12 | |
| 11 | |
| 10 |