Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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.
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.
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |