Forum Discussion
Advice needed : On-Demand Refresh Optimization
HI Anonymous ,
Current power bi not support to setting different schedule refresh plans on dataset tables.
For you scenario, I'd like to suggest you to use web connector to get sharepoint files and setting incremental refresh on azure sql table.
After you publish to service side, power bi will enable onedrive refresh on csv file and you can setting scheduled refresh of dataset to refresh azure sql database.
Notice:
1. Incremental refresh require premium license.
2. Please not use composite models on this report, it may disable onedrive refresh option.Regards,
Xiaoxin Sheng
HI Anonymous ,
Current power bi not support to setting different schedule refresh plans on dataset tables.
For you scenario, I'd like to suggest you to use web connector to get sharepoint files and setting incremental refresh on azure sql table.
After you publish to service side, power bi will enable onedrive refresh on csv file and you can setting scheduled refresh of dataset to refresh azure sql database.
Notice:
1. Incremental refresh require premium license.
2. Please not use composite models on this report, it may disable onedrive refresh option.
Regards,
Xiaoxin Sheng
Thank you for your answer, that was what I expected : different schedule refresh plans on dataset tables is not (yet?) accepted.
Incremental refresh would work so it's good to know. Now it's time to convince my company to go premium ;)