Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
sahilmehta9
Regular Visitor

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?

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

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-azur...

View solution in original post

2 REPLIES 2
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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-sq... 

 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




NandanHegde
Super User
Super User

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-azur...

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors