Forum Discussion

mjohannesson's avatar
mjohannesson
Advocate I
6 years ago
Solved

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 usin...
Need Help
darren-abraham's avatar
darren-abraham
New Member
6 years ago

Hi

  We tried the downgrade and it didnt work for us either.

After some investigation we found that refreshes in PBI online through the spark connector (to databricks) fails when the data contains datetime and/or decimal types. The same dataset would refresh against the same cluster in powerbi desktop however.

Within our databricks jobs we converted datetime to unix_time and decimal to float or double and the refresh works in both desktop and online PBI versions.

Hope this helps some of you out there.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 

It's working fine when we downgraded it to 5.5LTS

Hope this helps !

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      We are currently running Databricks 6.3, which should be fine, and it fails with the same error message. We opened a ticket with Microsoft.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous 

         

        we tried 6.3 but the issue didn't solve. So we further downgraded to 5.5LTS

         

        Thanks!