Forum Discussion
Database refresh breaking stored procedure
Hi nleuck,
As per my understanding, you have used SQL Stored Procedure(SP) to source data from your database into Power BI which is absolutely fine.
Now comes the question "What happens if you modify the Stored Procedure or refresh your SQL database"?
Untill and Unless your changes do not alter the schema which Power BI is consuming through your SP, it will not break your visuals or anything else.So feel free to refresh your SQL database.
Cheers !!
Hi scorreia,
This is weird. I tried on my machine and it works fine. Adding and Deleting columns in Stored Procedure are well detected by Power BI.
Anyway, try below steps. It might help:
1. Go to Query Editor, Open settings of the first step of the Power Query. Usually goes by name "Source" if you have not renamed.
2. Turn On "Enable SQL Server Failover Support" and click OK. If it is alreadt Turned ON then Turn it OFF.
3. Now Refresh and Check. It should work.
Prateek Raina
Hi Prateek,
I have a dashboard with 10 reports in Power BI, the data is coming from SQL strored Procedures through import mode.
The SQL Strored procedures will get updated with latest data when passing current date as input parameter to them, I want the same latest data in Power BI.The data in Power BI should always be the latest data like in the Stored Procedure could you please help on this.
I tried incremental refresh but it stores data from last refresh which I dont want.
I also tried calling function in Power BI but its always invoking a new table and my report is getting affected.
Please help