The data provider was unable to convert the value from the source data type 'VT_BSTR' the expected

[webportal]

I can't refresh this dataset in Power BI service, although it refreshes without issues in Power BI Desktop.

The error:

Processing errorThe following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table '<pii>tableA</pii>' column '<pii>Duration</pii>'. The data provider was unable to convert the value '<pii></pii>' from the source data type 'VT_BSTR' to the expected data type 'VT_CY'. Please check the column data types in the data model and data source and ensure that the data types are compatible. The current operation was cancelled because another operation in the transaction failed. The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: xxx

Column "Duration" is of Duration type. No errors are produced on Power BI Desktop upon full refresh.

[Anonymous]

The error message indicates a potential issue related to a value '<pii></pii>' within the source data type 'VT_BSTR' in your system. Upon closer inspection, it appears that the problem might be linked to the "Duration" column, suggesting the presence of a null or empty value. To resolve this, it is recommended to thoroughly examine the dataset, specifically the "Duration" column, and address any instances of null or empty values appropriately. Utilizing an enrichment tool can also prove beneficial in identifying and rectifying data discrepancies, thereby enhancing the overall data quality and resolving the reported error effectively.

[webportal · Accepted solution]

The solution I found was to delete the Duration column and calculate it again using DAX.

[v-cgao-msft]

Hi @webportal ，

Thanks for sharing the solution. Please mark your own method as a solution to help more people find it quickly.

Best Regards,
Community Support Team_Gao

[v-cgao-msft]

Hi @webportal ,

Please try.

1. In Power BI Service -> workspace -> Dataset + dataflows -> Select the dataflow and edit the table -> find the step named "Changed type" related to [Duration] -> delete this step -> Save & close -> Refresh now.

2. Or in Power BI Desktop -> File -> Options and settings -> Options ->CURRENT FILE ->Data Load, don't tick the option "Detect column types and headers for unstructured sources", save and republish to workspace.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[webportal]

Hi @GilbertQ 

There's no DataGateway. The data source is a Dataflow connected to an Azure Blob Storage.

[GilbertQ]

Hi @webportal 

Can you confirm that both PBI Desktop and the Gateway are on the latest version?

It could be that the mashup engine is a different version between PBI Desktop and the gateway?