Forum Discussion
Post PatronDifferent Ways to refresh power bi dataset reports
Hai All,
Appreciate support on this ,
What all are the different ways to refresh power bi datasets in the service level
We can use sheduled refresh in service level to refresh the power bi , but apart form the service is there any other way can we able to achive this ?
Using any microsoft power platform or azure ?
My excpetation is instead of using power bi service sheduled refresh other ways to refresh dataset in service
BR,
Alan P James
Hi AlanP514 ,
There are alternatives to refresh a dataset in Power BI service:
- You can set up scheduled refresh in Power BI service, as you described.
- You can trigger manual refresh in the UI of the Power BI web-app.
- You can trigger a dataset refresh from a Power Automate flow.
- 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.
- 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.
- 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
3 Replies
Martin_DSolution Sage
Hi AlanP514 ,
There are alternatives to refresh a dataset in Power BI service:
- You can set up scheduled refresh in Power BI service, as you described.
- You can trigger manual refresh in the UI of the Power BI web-app.
- You can trigger a dataset refresh from a Power Automate flow.
- 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.
- 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.
- 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
- Martin_D
Yes, any of the listed methods works also with MySQL except 6.
