cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dtrovato Frequent Visitor
Frequent Visitor

Scheduled Refresh against data source updates

Hi y'all!

 

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? 

 

 

 

 

6 REPLIES 6

Re: Scheduled Refresh against data source updates

HI @dtrovato,

 

I would think in this case it migt be a better option to setup a more confident schedule. This would prevent these errors if any from occurring.

Super User
Super User

Re: Scheduled Refresh against data source updates

@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.


Near SE WI? Join our PUG Milwaukee Brew City PUG
dtrovato Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh against data source updates

hi @richardlhughes , that's exactly what I had in mind, but in case of a random time you never know what the best settings are. Thanks for your suggestion though

dtrovato Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh against data source updates

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?

Super User
Super User

Re: Scheduled Refresh against data source updates

@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.


Near SE WI? Join our PUG Milwaukee Brew City PUG
Super User
Super User

Re: Scheduled Refresh against data source updates

Just a note with the dirty reads is that they still place a schema lock on the table. So if there is a dirty read happening and for example an Index rebuild is trying to start, it cannot start until the dirty read completes.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 811 guests
Please welcome our newest community members: