Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thanks @saambave! Now, it's working. Microsoft has now posted an awareness message to their support page about this:
We see the same issue with the same set-up.
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.
I too am having the same issue , my reports are not refreshing from june 12th. Did anyone find solution?
Same issue here with Databricks, Delta Tables, and Power BI.
We fasce the same issue with Databricks Spark connector and Power BI. We have opend a ticket but no answer yet ...
Exact same problem here, super frustrating. Sounds like same timing and same setup.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.