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...
Hi Drei
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks.
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.