Forum Discussion
Microsoft Fabric Notebook data from API Error
Failed to upload blockAuthentication Failed with Access token validation failed This is the error i always get when I try to import data from an API. It is a decent amount of data 36000 json file...
Spoiler
Hi all! I am very sorry to respond this late. But I have remove the workspace. It was kind of urgent and it did not work for me. No solution helped as I cannot lower the amount of data i need to import. I did try in partitions but did not help. I encounter a lot of errors in fabric when moving large amounts of data and will look for other solutions. I have been able to get all the data via local python code on a drive. So it is not an API problem but the problem is with the amount of data fabric can handle at once. Another example is when I have 30.000 rows of data and I standardize _z the data, I have it in my data frame, but when I write to parquet 70% of the times it fails.
Sorry to have bothered you all and I am glad to see how helpful you are! I hope fabric improves and become the main tool for data. As it is in concept a great idea!
Sorry to have bothered you all and I am glad to see how helpful you are! I hope fabric improves and become the main tool for data. As it is in concept a great idea!
I got the same error when tried to convert an excel file to a parquet one and store it in the data lakehouse. Surprisingly, resetting the standard session to the concurrent one and back to the standard helped. But maybe I just needed to reset the session, anyway, the error went away after that.