cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Conversion from number to string failed due to undersized character buffer

Thanks @saambave! Now, it's working. Microsoft has now posted an awareness message to their support page about this:

https://powerbi.microsoft.com/en-us/support/

View solution in original post

21 REPLIES 21
Highlighted
Super User V
Super User V

Re: Conversion from number to string failed due to undersized character buffer

Hi @mjohannesson 

 

If you haven't fixed the issue yet, you can always check if the issue was reported by others here:
https://community.powerbi.com/t5/Issues/idb-p/Issues

 

or if this did not give you the answer you looking for, you can create a support ticket here:

https://powerbi.microsoft.com/en-us/support/pro/

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Highlighted
Frequent Visitor

Re: Conversion from number to string failed due to undersized character buffer

Exact same problem here, super frustrating.  Sounds like same timing and same setup.

Highlighted
New Member

Re: Conversion from number to string failed due to undersized character buffer

We fasce the same issue with Databricks Spark connector and Power BI. We have opend a ticket but no answer yet ...

Highlighted
New Member

Re: Conversion from number to string failed due to undersized character buffer

Same issue here with Databricks, Delta Tables, and Power BI.

Highlighted
Regular Visitor

Re: Conversion from number to string failed due to undersized character buffer

I too am having the same issue , my reports are not refreshing from june 12th. Did anyone find solution?

Highlighted
Frequent Visitor

Re: Conversion from number to string failed due to undersized character buffer

Just put in a ticket as well.  This started occuring first early on 6/17.  Don't see any changes in source data or the Power Query settings.  But, it only seems to be impacting one load from Databricks Recast all fields in source query to no more than 2 decimal places... Stumped.

Highlighted
Advocate I
Advocate I

Re: Conversion from number to string failed due to undersized character buffer

We see the same issue with the same set-up.

Highlighted
New Member

Re: Conversion from number to string failed due to undersized character buffer

Same error since 17th June 2020. In our case when copying a table from Databricks to SQL Database with Data Factory. The pipeline was working fine until the error occurred. I think it might be a Databricks error and not PowerBI.

Highlighted
Frequent Visitor

Re: Conversion from number to string failed due to undersized character buffer

Yes, unfortunetly same here, since 17th June 2020.

 

Power BI connecting to Databricks using Spark connector trying to reach tables using Delta format.

 

Severity A case opened, almost all of our datasets are not refreshing anymore

 

If anyone found a workarround... would really be apreciated

 

Thanks

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors