Forum Discussion
Microsoft Fabric Notebook data from API Error
Hello Drei ,
From the error , its tough to tell which system is throwing the exception . if i were you i could have done this .
1. Narrow down to a smaller data set . may be just one JSON file and see is that works .
2.Tried to run the the API call using curl and Postman and see how it behaves .
Thanks
Himanshu
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.
- SpoilerHi 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!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.