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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
webportal
Impactful Individual
Impactful Individual

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

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.

1 ACCEPTED SOLUTION
webportal
Impactful Individual
Impactful Individual

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

View solution in original post

6 REPLIES 6
Racoon
Frequent Visitor

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
Impactful Individual
Impactful Individual

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

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
Community Support
Community Support

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.

vcgaomsft_0-1647314732487.png

 

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.

vcgaomsft_0-1647314029321.png

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
Impactful Individual
Impactful Individual

Hi @GilbertQ 

 

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

GilbertQ
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors