Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Can the source file be replaced

Hi,

The dashboard that I am building is based on an excel source but due to some circumstances I need to change the source from excel to csv, so I have converted my source file from excel to csv, but I still haven't changed the source in Power BI, my question is that will my dashboard still function if I replace the source from file in excel format to the same file but in csv format?

 

Thanks.

Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    Hi Anonymous ,

    Go to the Home tab in Power BI and click the button Transform Data.

     

    This will take you to Power Query. If you look at the picture below you will see how to get to the M code.  You can copy and paste that from one query to another so that everything downstream will stay the same.

     

    I highly reccomend this book by KenPuls 

     BTW, you can give kudos and accept solution from multiple people, so if we helped you move on, please feel free to give Anonymous  and myself those.

     


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel



     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous ,

    It will, How I will do it is as follows.

    Consider you have a "Source1" named Query which gets 10 columns.

    I would create another new Query "Source1 from csv" and get all the columns in same order and same column name and type as it was in previous Query.

    Once the "Source1 from csv" query looks good to implement, I will copy its M Code and paste it in the 1st query "Source1"

    Regards,

    Pranit

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

      Thanks for the reply.

      I am somewhat new to power bi, so I am ask what does M code mean?

      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Hi Anonymous ,

        Go to the Home tab in Power BI and click the button Transform Data.

         

        This will take you to Power Query. If you look at the picture below you will see how to get to the M code.  You can copy and paste that from one query to another so that everything downstream will stay the same.

         

        I highly reccomend this book by KenPuls 

         BTW, you can give kudos and accept solution from multiple people, so if we helped you move on, please feel free to give Anonymous  and myself those.

         


        Let me know if you have any questions.

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
        Nathaniel