Forum Discussion
OneDrive Refresh Frequency?
- 6 years ago
Basically the link explains about keeping the pbix files in OneDrive or SharePoint Team site. Not about connecting Power BI Desktop with excel files in OneDrive.
If you click Refresh Now button in dataset settings, it should bring all the row changes from your excel. (It may fail due to schema change or password expiration).
Check out the below links
https://docs.microsoft.com/en-us/power-bi/refresh-data#data-refresh
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂 - 6 years ago
Hi Lynk_RM .
Q1:Yes,it is loading all new changes which are made on the data source in Onedrive.
Q2:Refresh means datasets refresh which is linked to the excel file,and the visualizations will be refreshed synchronously
Q3:For onedrive,hourly is the only choice for refresh,if you wanna change the frequency,the best choice for you is to use a live connection way to connect with the data,such as SQL,etc..Then you will see "schedule cache refresh",where you can choose 15min,30min...Otherwise,you can only choose on-demand refresh ..
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Basically the link explains about keeping the pbix files in OneDrive or SharePoint Team site. Not about connecting Power BI Desktop with excel files in OneDrive.
If you click Refresh Now button in dataset settings, it should bring all the row changes from your excel. (It may fail due to schema change or password expiration).
Check out the below links
https://docs.microsoft.com/en-us/power-bi/refresh-data#data-refresh
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂