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 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
Need Help

27 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • jcwagnon's avatar
    jcwagnon
    New Member
    6 years ago

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

  • ChayDommeti's avatar
    ChayDommeti
    Frequent Visitor
    6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    Is there any update on this ?

     

     

    Thanks!

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