fetch live data from SQL Server

[Anonymous]

Hi,

I have reports in Power BI fetching data from the Stored Procedures in SQL Server, these stored procedures are being refresh daily so can anyone help me to get this updated data into my reports. 

Once the data is refreshed daily in the stored procedure I want the same refresh in Power BI reports.

Is this possible, please help

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the 5th reply of the thread:

https://community.powerbi.com/t5/Desktop/Calling-SQL-stored-procedure-with-Direct-Query/td-p/224831 

Other similar:

https://community.powerbi.com/t5/Power-Query/DirectQuery-with-stored-procedure-using-temptables/td-p/396015 

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

[amitchandak]

@Anonymous , see if you can configure Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/