Automate power bi dataset and report refresh through pipeline in MS Fabric

[Dipesh123]

I hae creaed pipeline to get data from source, save it in warehouse and process it . I have created power bi report on the basis od that data set. If there are any changes in source daa , I run pipeline to refresh dataset , but to refresh power BI report a I have to manually click on refresh button on report. Is there any way I can automate refresh of power bi report whenver i run the pipeline?

[LeoFabric]

Hi @n0elleli , any updates on this on your side? 🙂 

[NandanHegde]

Hey, You can use web activity at the end of your pipeline to trigger the REST API to refresh your Powerbi dataflow and datasetvia service principal authentication. 

Note : Since Managed Identity is not supported, you would have to pass the Secert as Secure string parameter.

https://datasharkx.wordpress.com/2022/11/07/refresh-power-bi-dataflow-dataset-from-azure-data-factor...

[Anonymous]

Hello, @n0elleli!

Is there already the possibility of reporting Power BI updates automatically within Fabric?

[n0elleli]

Not at the moment, but this capability is coming soon!