Forum Discussion
Dataset failed to refresh - Unable to convert a value to the data type
Failure details: The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table 'DimPlantDetails' column 'TargetHours'. The data provider was unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'. Please check the column data types in the data model and data source and ensure that the data types are compatible
Hi,
powerBI schedule service failed to refresh and its showing me this error. PowerBI desktop refresh alright.
How can i fix this ? i am using sql server, onpremises.
cheers,
6 Replies
Hi Anonymous ,
It sounds like a common issue when your datasource fields changed and it not matched with stored data structure.
For this issue, you need to enter to query editor to fix data fields and republish to power bi service.
Troubleshooting refresh scenarios
Regards,
Xiaoxin Sheng
Hi,
I'm sorry, another update.
Yesterday i've tried to manually 'push for refresh dataset because i want the report before the schedule time and i thought its the same as waiting for schedule refresh.
Apparently, it is not. The schedule refresh ran without a problem, however when i go into the report the 'new' data is not showing. Please see attached. It supposed to show 'last work day' which is 24.06.19.
let me know any updates, get the same problem.
