Forum Discussion

HenriqueRodrig's avatar
HenriqueRodrig
Regular Visitor
2 years ago
Solved

Update dataflow after data is added to SQL

Good afternoon, friends, how are you? I have a SQL database that updates every hour exactly. Since the data may take between 1 to 5 minutes to update, I would like my dataflow to be automatically up...
dataflow
  • ibarrau's avatar
    ibarrau
    2 years ago

    Hi. I think this is not a power bi issue but a SQL Server one.

    I know that you can create Triggers for a database to run actions when something happens. You might want to read more about that. The key here is catching that event, once you can do it, it's a matter of running a Power Bi Rest API request to refresh the dataflow.

    If the SQL database is in Azure, there might be something on logic apps or power automate. If it's on premise it would be reading more about Triggers probably.

    I hope that helps,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
2 years ago

Hi. I think this is not a power bi issue but a SQL Server one.

I know that you can create Triggers for a database to run actions when something happens. You might want to read more about that. The key here is catching that event, once you can do it, it's a matter of running a Power Bi Rest API request to refresh the dataflow.

If the SQL database is in Azure, there might be something on logic apps or power automate. If it's on premise it would be reading more about Triggers probably.

I hope that helps,