Forum Discussion

nleuck's avatar
nleuck
Post Patron
9 years ago
Solved

Database refresh breaking stored procedure

Hello,   I have a question concerning stored procedures being used in Power BI desktop and refreshing the SQL database that they are imported from. I imported a stored procedure to the Power BI des...
Need Help
  • prateekraina's avatar
    prateekraina
    9 years ago

    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 !!

prateekraina's avatar
prateekraina
Memorable Member
9 years ago

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 !!

  • scorreia's avatar
    scorreia
    Regular Visitor
    8 years ago

    Hi Prateek,

    I have a question. I am using a Stored Procedure inside Power BI Desktop using Import Mode. I created my visualization and everything works fine.

    Now I added 2 more fields in my Stored Procedure and want to use them in Power BI. I tried Refreshing in the Query Editor but could not see the 2 new columns added to power BI.

    Please can you advise?

    Thanks

    Sophia

    • prateekraina's avatar
      prateekraina
      Memorable Member
      8 years ago

      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

      • scorreia's avatar
        scorreia
        Regular Visitor
        8 years ago

        Hi Prateek,

        This is getting refreshed automatically. My bad as I was updating the Stored Proc in a Test Database and not in the one where Power BI was pointing to.

         

        Thanks.

         

        Regards

        Sophia