Conversion from number to string failed due to undersized character buffer

[mjohannesson]

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

[gah113]

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

[Anonymous]

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.

[ChayDommeti]

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

[jcwagnon]

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

[Anonymous]

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

[Anonymous]

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

[Mariusz]

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