I'm looking for a document that explains what happens with the following scenario:
- power bi service, with a scheduled refresh every t1-time, connected to an azure data source
- that data source is updated with a t2-random time
if t1 = t2, what happens to the reports in the service?
does it throw an error or show the "old" report?
in case of an error...how to handle it?
@dtrovato Are you suggesting that the data table in the database is being updated, and there could be a conflict when the Dataset in Power BI refreshes and when the table refreshes?
Depending on your access methods and what is happening in the datasource. It could lock and force a wait, which may time out. You could dirty read from the source, if the data source refreshed quickly it could return after the fact as a call would be in process... a number of things could happen.
hi @Seth_C_Bauer, yes that's what I'm suggesting and I agree on that a number of things can happen. Just wondered if there was any doc.
Anyway, what do you mean with "dirty read from the source"? Still using Power BI?
@dtrovato If your queries include "with(nolock)" they will perform dirty reads on the data. This means that the query will run and return data despite any locks being held on the table. The "dirty" means that if there is a process writing against the table as you query it, you may get the "old" data. In many cases this is ok, in others it wouldn't be. Depends largely on what you are reporting on.