The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've started to see errors when posting rows. Some of my posts still work, but quite a few of these errors occur.
The error message returned from the post is InternalServerError (HTTP 500) and the response body is
{"error":{ "code":"GeneralException", "message":"Failed to process dataset PostRows", "target":"PostRows", "details":[ {"message":"Exception of type 'Microsoft.Cloud.Platform.Utils.AcquireLockTimeoutException' was thrown."} ]}}
I'm also seeing slow response times for posts to the same dataset. 125 rows are taking 25 seconds, where as 25 entries to another dataset are taking less than 1 second. Everything is working, but it's slow and my real time chart that should update every second is not as smooth as it should be!
Hi, we are facing the same issue here.
Status Code: InternalServerError
Response Content: {"error":{"code":"GeneralException","message":"Failed to process dataset PostRows","target":"PostRows","details":[{"message":"Exception of type 'Microsoft.Cloud.Platform.Utils.AcquireLockTimeoutException' was thrown."}]}}
Did you manage to find out what it is?
What is the dataset? A PUSH dataset created via REST API or a Streaming dataset?
By the way, how busy is the data pushing, just keep in mind that there're limitations for streaming dataset and REST API.
Hi, did you manage to find out what the issue is here? Were facing the exact same issue when making http calls from an Azure Function to PBI.
It's a push dataset created using the REST API. I'm only pushing rows once a second having hit the 429 rate limit error too many times.
At the moment I'm not seeing those errors, but on the day I posted it a lot were happening.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |