topic Re: Different Ways to refresh power bi dataset reports in Developer

Different Ways to refresh power bi dataset reports

AlanP514 — Fri, 25 Aug 2023 08:50:38 GMT

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

Re: Different Ways to refresh power bi dataset reports

Martin_D — Fri, 25 Aug 2023 20:45:34 GMT

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.

Martin

Re: Different Ways to refresh power bi dataset reports

AlanP514 — Mon, 28 Aug 2023 05:03:38 GMT

Hai
@Martin_D

Thanks for the information ,
Can we able to Refresh power BI Dataset which is configured with Mysql Database using power automate or any other method excpect power bi service sheduled refresh

Re: Different Ways to refresh power bi dataset reports

Martin_D — Mon, 28 Aug 2023 07:06:40 GMT

Yes, any of the listed methods works also with MySQL except 6.