cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Conversion from number to string failed due to undersized character buffer

Starting yesterday afternoon, several of our datasets have failed to refresh with the below error. What is the reason for this error? Our datasets imports data from Databricks Spark Delta tables using the Spark connector into our Premium P1 capacity. I have restarted the Databricks cluster once after this error started occurring, but it did not help.

 

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: ERROR [HY000] [Microsoft][Support] (50130) Conversion from number to string failed due to undersized character buffer.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: MyTable.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
21 REPLIES 21

We were facing same issue.

you can set configuration “spark.thriftserver.arrowBasedRowSet.enabled false” under Advanced options -> Spark tab in any Databricks and restart cluster.

This fixed the issue for us

Highlighted
Helper I
Helper I

I'm not an admin on my Databricks implementation, so I don't want to mess around with configurations under advanced options for my cluster if I can avoid it. But this update was just provided on the support page (https://powerbi.microsoft.com/en-us/support/), so I think I'll just hold and wait for this:

 

"Engineers are working on a fix and expect it to be deployed by end-of-day 07/01/2020."

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors