cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
corpsikumar
Regular Visitor

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

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,

2 ACCEPTED SOLUTIONS
HusnaBanu413
Super User II
Super User II

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

 

Regarrds,

Husna

View solution in original post

v-henryk-mstf
Community Support
Community Support

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.

v-henryk-mstf_0-1620107131021.pngv-henryk-mstf_1-1620107169235.png

v-henryk-mstf_2-1620107318637.png

 

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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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.

v-henryk-mstf_0-1620107131021.pngv-henryk-mstf_1-1620107169235.png

v-henryk-mstf_2-1620107318637.png

 

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.

View solution in original post

HusnaBanu413
Super User II
Super User II

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

 

Regarrds,

Husna

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors