cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
csabil Advocate II
Advocate II

scheduled refresh timing problem

As now the credentials problems are solved, I was trying to setup scheduled refresh, but the system says that the next refresh will be in year 9999.

 

Also can somebody please explain, how frequent is the default refresh for excel file source stored on SharePoint online? A lot of sources say hourly refresh, but I'm trying now only to implement the free subscription. Although I've started the 60 day pro trial, but the dasboards are shared with many people with free accounts.

 

Thanks for the help

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-haibl-msft
Microsoft

Re: scheduled refresh timing problem

@csabil

 

If you get data from OneDrive/SharePoint directly in Power BI Service as below. You should be able to refresh hourly with free account.

 

scheduled refresh timing problem_1.jpgscheduled refresh timing problem_2.jpg

 

If you get data from an excel stored in SharePoint in Power BI Desktop, then publish to Power BI Service. You need to be Pro user if you want to refresh multiple times in one day.

According to this document,  data from a dataset that refreshes more frequently than daily is Power BI Pro content. If you create a manufacturing dashboard that updates progress multiple times during the day, anyone consuming that dashboard would need a Power BI Pro license.

 

Best Regards,

Herbert

View solution in original post

csabil Advocate II
Advocate II

Re: scheduled refresh timing problem

@v-haibl-msft

 

Thank you for the clarification, now it is clear. So the problem is that I used PBI Desktop and published the report. If I connect to the same data in the PBI Service, that would refresh hourly even with a free account.

 

Thank you for the help.

 

Regards,

Csaba

View solution in original post

7 REPLIES 7
csabil Advocate II
Advocate II

Re: scheduled refresh timing problem

Here's the screenshot about the refresh settings:

 

Capture.PNG

 

 

Microsoft v-haibl-msft
Microsoft

Re: scheduled refresh timing problem

@csabil

 

According to this official document, Power BI check for updates automatically about every hour. Could you please check in Refresh history to see if refresh is triggered for your dataset since last refresh, even it shows the next refresh will be in year 9999?

 

Best Regards,

Herbert

csabil Advocate II
Advocate II

Re: scheduled refresh timing problem

I assumed the same, that it should happen hourly, but it does not. The issue with the year is solved, but it only refreshes daily. Also this is showed in the Refresh hístiry, the 'scheduled' refreshes happen every day short after midnight.
This is not clearly documented. I started my pro trial, so my account should be pro, but the dashboards are shared with people with free accounts.

For now I want to make things work with the free version, as we're still in trial mode in my company.

Microsoft v-haibl-msft
Microsoft

Re: scheduled refresh timing problem

@csabil

 

Please try to click “Add another time” in your screenshot, and add the refresh time in one day. In that way, you should be able to refresh every hour.

 

Best Regards,

Herbert

csabil Advocate II
Advocate II

Re: scheduled refresh timing problem

For one of my datasets I've set that and now, people with free accounts get the message, that the report has Pro content. I've checked with a colleauge who has the free account, and it seems that only the daily refresh is available, but a 6 hour time frame can be chosen when the refresh should happen.

The documentation is not clear, or assumes a pro account by default.

Microsoft v-haibl-msft
Microsoft

Re: scheduled refresh timing problem

@csabil

 

If you get data from OneDrive/SharePoint directly in Power BI Service as below. You should be able to refresh hourly with free account.

 

scheduled refresh timing problem_1.jpgscheduled refresh timing problem_2.jpg

 

If you get data from an excel stored in SharePoint in Power BI Desktop, then publish to Power BI Service. You need to be Pro user if you want to refresh multiple times in one day.

According to this document,  data from a dataset that refreshes more frequently than daily is Power BI Pro content. If you create a manufacturing dashboard that updates progress multiple times during the day, anyone consuming that dashboard would need a Power BI Pro license.

 

Best Regards,

Herbert

View solution in original post

csabil Advocate II
Advocate II

Re: scheduled refresh timing problem

@v-haibl-msft

 

Thank you for the clarification, now it is clear. So the problem is that I used PBI Desktop and published the report. If I connect to the same data in the PBI Service, that would refresh hourly even with a free account.

 

Thank you for the help.

 

Regards,

Csaba

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors