Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
adcook
Frequent Visitor

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 2
v-lili6-msft
Community Support
Community Support

hi  @adcook 

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

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
darentengmfs
Post Prodigy
Post Prodigy

Hi @adcook 

 

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors