Forum Discussion
Is the data refresh an atomic operation?
When I share a dashboard with my team, I can set it to show the last refreshed date. Since the dashboard uses a dataset that has mutiple datasources, a question has come up with regards to what ...
paulwozniak - So, I tested this out with 2 SharePoint lists. After I removed one of the SharePoint lists, data refresh failed and the other query did not update new items in the remaining list. So, my thought is not atomic. Seems like there is some kind of preprocessing step that must do some sort of check prior to running through the queries.
O365 Power BI refresh was atomic, but it does not appear that Power BI is.
Data refresh is atomic because there is one in-memory database for each dataset. When PowerBI processes the database, which is triggered by data refresh, it's done in a single transaction, so you will either not get any new data if refresh fails, or get new data if refresh succeeds. Hope this helps.