Forum Discussion
Sharepoint Online List - Refresh
Community ChampionI hope I don't prevent others answering in the case I am off about this. This is what i understand.
Files stored on SharePoint online are auto refreshed. SharePoint Lists are an online source and hence are not auto refreshed but can be configured to refresh from Power BI
if keep up to date is off, it is because it is not available for some reason. Maybe there is no gateway. What is different about this dataset?
Hi Matt,
Many thanks for your response. So i presume that files stored on Sharepoint Online are 'auto refreshed' without the need for a pro licence? Therefore the scheuled refresh tab is set to off.
As for data on lists, they require either a manual intervation to refresh or a pro licence to configure a scheudle refresh, i.e. the schedule refresh tab set to on?
Theres nothing partiularly wrong about this dataset. I am a pro user and as such set the data sources up so that they had scheduled refreshes throughout the day. Most of our users however are free users and, as of last week as per the power-bi team's post - http://community.powerbi.com/t5/Service/bd-p/power-bi-web-app) they can no longer click 'cancel' and view the report. I have had to disable the scheduled refreshes as in order that the report does not containany pro features so that everyone can view them. If the excel/csv files refresh 'automatically' then that just leaves some data from online lists that i might have to manually refresh.
Rich
v-ljerr-msftMicrosoft Employee
Hi Smithy32,
So i presume that files stored on Sharepoint Online are 'auto refreshed' without the need for a pro licence? Therefore the scheuled refresh tab is set to off.Yes, when the file is on OneDrive, or SharePoint Online, Power BI will synchronize any changes to the file with the dataset automatically about every hour. No schedule refresh is needed in this scenario.
As for data on lists, they require either a manual intervation to refresh or a pro licence to configure a scheudle refresh, i.e. the schedule refresh tab set to on?
In this scenario, a manual/schedule is needed. In order to share your dashboard with other free users, you can either manual refresh your dataset, or set a daily schedule refresh for your dataset. Because only data from a dataset that refreshes more frequently than daily is Power BI Pro content.
Regards
Hi,
Many thanks for your reply, i am only just getting round to testing the solution as i've been on leave.
I have a dataset that contains a mixture of csv/excel files & a summary table built into the report. When schedule refresh is set to off, when i update the csv/excel files nothing happens unless i click on 'Refresh Now' on the dataset. I left this for 5 days and nothing updated.
I have another report similar to the above that also contains sharepoint online data. When i set the refresh schedule to weekly, power-bi is still clasifying the content as pro. Not quite sure why? I know this as when i go to share the dashboard there is a notification telling me that 'This dashboard contains Power BI Pro content. Only users that have Power BI Pro will have access to it'.
Not sure what to do now...
Hi,
Could you please confirm if this still holds true?
From what I understand sharing the dashboards with other users requires PRO license ( regardless of scheduled refresh frequency)
Thanks in advance.
Best,
PP
