Different Ways to refresh power bi dataset reports

Hi AlanP514 ,

There are alternatives to refresh a dataset in Power BI service:

1. You can set up scheduled refresh in Power BI service, as you described.
2. You can trigger manual refresh in the UI of the Power BI web-app.
3. You can trigger a dataset refresh from a Power Automate flow.
4. You can trigger refresh through Power BI REST API. There are PowerShell CmdLets that encapsulate the Power BI REST API. You can call this from any tool or programming language of your choice. PowerShell makes it easy.
5. You can trigger refresh through XMLA API. This also allows you to choose between refreshing a complete dataset, selected tables only or even selected partitions only. There are PowerShell CmdLets that encapsulate the XMLA API. You can use any tool or programming language of your choice to implement the refresh, including PowerShell, C#, SSMS, Tabular Editor.
6. If your data source is Excel on OneDrive, refresh happens automatically when changes in the Excel files occur.

Be aware that available options and posible refresh frequency depend on available licenses and tenant settings from your Power BI admin. Some options require Power BI Premium or Power BI Premium per User workspaces.

BR

Martin