Forum Discussion

Regular Visitor

3 years ago

Solved

Trigger dataset refresh instantaneously data is ingested in Database

We have a report for which the source is Azure SQL DB. Is there any way to refersh the dataset instantaneously once the data is ingested in Azure SQL database?

Need Help

NandanHegde
3 years ago
Hey,
there is a feature in preview in Azure SQL database of direct integration with APIs.
you can levearge that and mix it in combination with database triggers:

https://datasharkx.wordpress.com/2022/11/29/event-trigger-power-bi-dataset-dataflow-refresh-via-azure-sql-database/

StefanoGrimaldi

Resident Rockstar

3 years ago

hey, check out this article and video that explains step by step how to get this done via power automate:

https://techcommunity.microsoft.com/t5/healthcare-and-life-sciences/use-power-automate-with-azure-sql-db-to-trigger-a-power-bi/ba-p/1348614

Forum Discussion

Trigger dataset refresh instantaneously data is ingested in Database

Related content

How to reset Eventhouse Ingestion from Batching to Streaming ?

Data Ingestion Troubles

External File ingestion

Database connectivity.

Can't ingest via API/Eventsteam - Notebook hanging