Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Change mysql view from visualization

Hi,

I have created dashboard with mysql views, I have A view and duplicated and renamed as B. With the same columns names and data,
Can I connect to the A view changes to B view without affecting visualization and logics. Because we have same column names and data.
I tried with advanced editer, its not successful, 

How can I do that ?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous  you can go to advance editor in  Power query and replace the view name.

     

     

    You will have a script ...Find the view name and replace with the new view name.

     


    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

    Regards,

    Husna

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , You have to do that power query, in advance property

    very similar to what I done for column

    How to Deal with Column Rename at Source: https://youtu.be/meUxcbwujl8

     

    you have to do for table name 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, 
      Issue is not renaming columns in this vedio,  I need to change whole mysql view name

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Anonymous  you can go to advance editor in  Power query and replace the view name.

         

         

        You will have a script ...Find the view name and replace with the new view name.

         


        Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

        Regards,

        Husna