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
mjohannesson's avatar
mjohannesson
Advocate I
6 years ago

I raised a ticket with Microsoft on June 18th, but they haven't yet found a solution.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks mjohannesson MS recommend to use Databricks Version lower than 6.4. But no luck!

  • 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 !