To refresh Power BI reports from SQL Stored Procedures with live data

Hi,

I have created a dashboard with multiple reports in it whose data is coming from SQL Server Stored Procedures.

These Strored Procedures upon calling and passing current date as input parameter will give the latest data.

I want my reports also to reflect this lastest data in Power BI.

Is this possible please help me through this.

I have followed below link to create dynamic parameters in Power BI, its working fine but problem is whenever I ivoke the function with a new date the Power BI is creating a new table "Invoked Function". I want my reports to refelect this new data but not creating a new report all over again.

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/

Any help is highly appreciated.

Thanks in Advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
I think it won't be any problem since refresh time or schedule data refresh is configurable in Power BI. You can schedule cache refresh.

Get more details:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
+2