Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sunayanababudas
Frequent Visitor

Setting scheduled refresh for multiple time zones for the same report

Hi All, 

 

I have a report that I created for the North American Zone where users from different time zones use the report when their shifts start to get a summary of what happened in the previous shift. Currently I have the report to refresh at shift start and once in between. But this only works for users in CST. 

Screen Shot 2022-11-08 at 11.41.31 AM.png

For example, morning shift starts at 7am and for ET users, when they open their report at 7am ET, their last updated data is from 3am ET which misses out on a whole bunch of data. For PT users, their last updated time would be 5am PT since it updates 7am CT as per the refresh set which again means PT users miss out on 2 hours of data. 

 

Also I have to mention the data source for this report is Azure SQL DB which only refreshes every 3 hours CT and the whole Azure pipeline takes about 1.5 hours to complete the refresh. Which is why the refreshes are set every 3 hours in Azure and the report refreshes are set as pictured time above. 

 

My question is how do I set the refreshes in Power BI to get it to refresh for all the timezone users at their shift start? Would I have to set Azure refreshes at different intervals? Any suggestions and thoughts are welcome!

 

Thanks in advance! 

 

Cheers, 

Sunayana

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @sunayanababudas ,

 

I am wondering if you think about this differently it might resolve your problem.  Think about that data side of the equation and not the users (or where the users are from).

Your limit is that the data refreshes every 3 hours.  Therefore, you can't refresh any faster than that in Power BI.  You can only set the refresh in Power BI to happen after each refresh happens in Azure.  So, you can have 8 refreshes a day with new data.  

The limiter is not Power BI or timezone for the users - it is how often your data itself is refreshed.

If you truly want to have refreshed data when the users' shifts start you will need to back up the Azure refresh to meet the time that users come in.  But, with a 3 hour cycle, you are unable to get EST, CST, MST and PST to get fresh data.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

1 REPLY 1
collinq
Super User
Super User

Hi @sunayanababudas ,

 

I am wondering if you think about this differently it might resolve your problem.  Think about that data side of the equation and not the users (or where the users are from).

Your limit is that the data refreshes every 3 hours.  Therefore, you can't refresh any faster than that in Power BI.  You can only set the refresh in Power BI to happen after each refresh happens in Azure.  So, you can have 8 refreshes a day with new data.  

The limiter is not Power BI or timezone for the users - it is how often your data itself is refreshed.

If you truly want to have refreshed data when the users' shifts start you will need to back up the Azure refresh to meet the time that users come in.  But, with a 3 hour cycle, you are unable to get EST, CST, MST and PST to get fresh data.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors