Power BI /Tableau Dataset Need to refresh

Question

Hello Team,

I have requirement, Where the Power BI/Tableau Dataset need to refresh after the ADF Pipeline ran successfully without any manual Interference.

How this can be achievable

Regards

Rohit

Answer 1

Hello @Rohit Kulkarni,

You can use Rest APIs from Power BI to refresh a dataset once the pipeline is complete. This exact requirement is documented in this below blog post

https://microsoft-bitools.blogspot.com/2022/03/refresh-power-bi-datasets-with-adf-or.html

Power BI rest Api document: https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

I hope this helps. Please let me know if you have any further questions.

Answer 2

On Top of what Bhargava stated,

Similar to Power BI , Tableau also have REST APIs for integrations.
You can use notebook or web activity to trigger the REST APIs :

https://www.youtube.com/watch?v=bkGf5VSaTQw

For Power BI :

https://datasharkx.wordpress.com/2022/11/05/refresh-power-bi-dataflow-dataset-from-azure-data-factory-synapse-pipeline-via-managed-identity/

https://datasharkx.wordpress.com/2022/11/07/refresh-power-bi-dataflow-dataset-from-azure-data-factory-synapse-pipeline-via-service-principal-part-2/