Refresh reports based on data loaded in table

[powerbiexpert22]

Is it possible to refresh reports in power bi once data is loaded in table in database?

[ibarrau]

Hi. If you can know when the table is loading at the database, then sure. For example, when working with azure or fabric, you might load data to lakehouses or warehouses. Once that process finishes, you might want to refresh the power bi dataset. Data Factory is a tool that help you orchestrate the flow of data. Once it's moved it can call the Power Bi Rest API to refresh the dataset. The same would be there. If you can capture the moment when the table finishes loading at the database, you can request a refresh of a power bi dataset using the Rest API.

I hope that helps,

[powerbiexpert22]

Hi @ibarrau ,

we have been using SQL Server on premises data warehouse , in this case how do we call rest api?

[ibarrau]

Well I'm not a SQL Server on premise expert but I have seen people creating triggers for operations like when rows are added to a table run something. I have also seen people using SQL to run an http request. Maybe you can configure a trigger that runs a request for refreshing the dataset. Another approach would be asking the trigger to run a local script for refreshing the dataset. You can build the script with many languages like powershell and run it from the sql server.

I hope that helps,

P/D if you are using integration services, there might be something to play with that too.