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
Solved! Go to Solution.
If you haven't fixed the issue yet, you can always check if the issue was reported by others here:
or if this did not give you the answer you looking for, you can create a support ticket here:
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.
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.
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
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.