Refresh dataset automatically when we change any records from the SQL table in power bi .

[corpsikumar]

Hi,

I have created a report and SQL table as a data source. Is there any way to dynamically update data in Power Bi report when we there is a new records inserted in SQL table. One way to schedule refresh but requirement is to instantly reflect the updated data In schedule refresh.

I can use power automate for this but we have only basic license and we don't have a Power BI report server as well.

Thanks,

[corpsikumar]

Hi,

I have created a report and SQL table as a data source. Is there any way to dynamically update data in Power Bi report when we there is a new records inserted in SQL table. One way to schedule refresh but requirement is to instantly reflect the updated data In schedule refresh.

I can use power automate for this but we have only basic license and we don't have a Power BI report server as well.

Thanks,

[Anonymous · Accepted solution]

@corpsikumar you can make use of live connection to SQL to get the live data .

Regarrds,

Husna

[v-henryk-mstf · Accepted solution]

Hi @corpsikumar ,

According to your needs, when the data in the data source is modified in powerbi desktop, you can directly click the "refresh" function, and it will be directly updated to the latest data from the data source.

Here is the reference document link:Refresh a dataset created from a Power BI Desktop file - local - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@corpsikumar you can make use of live connection to SQL to get the live data .

Regarrds,

Husna