Forum Discussion
Power BI scheduled refresh functionality is not enabled
Here is the link to the 2.0 beta connector, which, at least in my implementations, have proven to be alot faster on refresh: Power Query SharePoint Online list connector - Power Query | Microsoft Docs
As for your second question, it may be possible to kick off a power automate script to initiate a refresh, but I am not sure.
Further testing proved the scheduled refresh works as expected. The only issue remaining is the time it takse to perform the refresh (at least 20-30 min). Do you have a link to info on the updated SharePoint connector? First I heard of it.
Additional question. The reports (launched from links in a SharePoint page) do not have a way to launch an on demand refresh. Is there a way to put on demand refresh on the displayed page?
Here is the link to the 2.0 beta connector, which, at least in my implementations, have proven to be alot faster on refresh: Power Query SharePoint Online list connector - Power Query | Microsoft Docs
As for your second question, it may be possible to kick off a power automate script to initiate a refresh, but I am not sure.
Good point on Power Automate. Created a number of flows, just not involving Powrt BI. Will look into it. Thanks for the helpful responses.