Forum Discussion
Randomly cannot "acquire exclusive access to dataset" when using the Rest API
We are working on a real time dashboard where my team and I have chosen to push data using the Rest API (as opposed to using Streaming Analyitcs), as this gives us the ability reset the data at any given time as we've found no other way of displaying today's and this week's data in the Service. We push data at most every 10 seconds, and clear the datasets either dayly or weekly depending on what data they hold.
Now, when either pushing new rows, or clearing datasets, we randomly return error messages saying "Acquiring exclusive access to dataset <dataset_id> timed out. Please try again later.". Is this a fault on our side, or is it something with Power BI? Has anyone else had this issue?
I've been in contact with Microsoft on multiple occasions, but every time, the service (and API) seems to have been working as expected. So there hasn't been much to discuss there.
Sidenote:
I've chosen to put this under Developer instead of under Service as this is presumably more about the Rest API than Service. I'm happy to repost this in Service if that's a more suitable forum.
10 Replies
- bsjut
Advocate II
We've started seeing this today, as well. Interesting ly, also the frontend is then unable to access the dataset anymore. It just displays an error level. To me it looks like a data integrity issue on the data model side?
- bsjut
Advocate II
This is happening as of today again; The affected dataset is
213d2dfb-1ed9-420a-96e5-a9a6ea1239d8
If anybody from Microsoft reading this: Can you comment if this is a know issue? The rest API is firing 500 errors
- bsjut
Advocate II
jocaplan-MSFT, do you know who would be the right person to escalate this to?